[GENERAL] forums.postgresql.com.au

2011-04-06 Thread Elliot Chance
Hi Everyone, It has been a long time since this was brought up. It's time. Any important concerns should be discussed at (to keep everyone looking at the same place): http://wiki.postgresql.org/wiki/Forums_at_postgresql.com.au But also keep general discussion on the mailing list. - The

[GENERAL] forums.postgresql.com.au

2011-04-06 Thread Elliot Chance
Hi Everyone, It has been a long time since this was brought up. It's time. Any important concerns should be discussed at (to keep everyone looking at the same place): http://wiki.postgresql.org/wiki/Forums_at_postgresql.com.au But also keep general discussion on the mailing list. - The

Fwd: [GENERAL] Postgres forums ... take 2

2010-12-30 Thread Elliot Chance
Sorry folks, this is an old message I forgot to copy pgsql-general on. Begin forwarded message: From: Elliot Chance elliotcha...@gmail.com Date: 21 December 2010 11:48:07 AM AEDT To: Thom Brown t...@linux.com Subject: Re: [GENERAL] Postgres forums ... take 2 On 21/12/2010, at 11:26 AM

Re: [GENERAL] Postgres forums ... take 2

2010-12-30 Thread Elliot Chance
On 31/12/2010, at 12:43 AM, Carlos Mennens wrote: On Mon, Dec 20, 2010 at 7:26 PM, Thom Brown t...@linux.com wrote: I know this topic has gone quiet, I still think it's worth investing time and resources in. I don't expect any progress to be made until the new year now, but I hope we can

Re: [GENERAL] #include funcapi.h

2010-12-26 Thread Elliot Chance
#undef typename #ifdef PG_MODULE_MAGIC PG_MODULE_MAGIC; #endif }; Now there is no collision with the C++ keywords. On 26/12/2010, at 5:14 PM, Craig Ringer wrote: On 12/26/2010 02:14 PM, Elliot Chance wrote: In file included from /usr/include/pgsql/server/access/heapam.h

[GENERAL] C functions with COMMIT/ROLLBACK?

2010-12-26 Thread Elliot Chance
Hi everyone, Is is possible to add handlers so that a C function is fired when a transaction is committed or rolled back, for example (pseudo code): BEGIN; CALL my_function(1); CALL my_function(2); CALL my_function(3); ROLLACK; my_function() Create my_file.txt.tmp Write some information to

[GENERAL] SQL queries inside a C function?

2010-12-26 Thread Elliot Chance
Hi everyone, How do I get the active connection handle from inside a C function linked as a PL/pgSQL function, like: Datum pg_do_something(PG_FUNCTION_ARGS) { PGconn *conn = ? // now do some SELECTs / INSERTs PG_RETURN_INT32(result); } Thanks, Elliot -- Sent via pgsql-general

[GENERAL] #include funcapi.h

2010-12-25 Thread Elliot Chance
Hi everyone, From what i've read in the documentation you need funcapi.h to return SETOF from a C function, the problem is when I include the header file the compile throws heaps of errors; offending code 1. extern C { 2. #include postgres.h 3. #include fmgr.h 4. #include

[GENERAL] Load C++ for functions?

2010-12-24 Thread Elliot Chance
I'm trying to link up a C++ project with postgres functions, the following code compiles (as C++): extern C { #include postgres.h #include fmgr.h #ifdef PG_MODULE_MAGIC PG_MODULE_MAGIC; #endif }; extern C { PG_FUNCTION_INFO_V1(pg_xversion); };

Re: [GENERAL] Load C++ for functions?

2010-12-24 Thread Elliot Chance
Cheers! It works. On 24/12/2010, at 11:13 PM, Dmitriy Igrishin wrote: Hey Elliot, See http://www.postgresql.org/docs/9.0/static/extend-cpp.html Probably compiling with -fno-exceptions solve you problem. 2010/12/24 Elliot Chance elliotcha...@gmail.com I'm trying to link up a C

[GENERAL] RAISE with C?

2010-12-20 Thread Elliot Chance
Hi, Is it possible to do the equivalent of RAISE EXCEPTION inside a C-function? Like this: PG_FUNCTION_INFO_V1(check_something); Datum check_something(PG_FUNCTION_ARGS) { // RAISE EXCEPTION 'bla bla' } CREATE OR REPLACE FUNCTION do_check() RETURNS text AS $$ BEGIN PERFORM

[GENERAL] Recreate C functions?

2010-12-14 Thread Elliot Chance
Hi, I seem to be having trouble recreating C functions, the source: === test.c #include postgres.h #include fmgr.h PG_MODULE_MAGIC; int32 plpgsql_test(text* s) { return 100; } === end === Then compile: $ cc -fpic -c -I/usr/include/pgsql/server test.c $ ld -shared -o funcs.so test.o

Fwd: [GENERAL] Recreate C functions?

2010-12-14 Thread Elliot Chance
or reload while the server it running? I couldn't find anything in the docs about it though. Regards Pavel Stehule 2010/12/14 Elliot Chance elliotcha...@gmail.com: Hi, I seem to be having trouble recreating C functions, the source: === test.c #include postgres.h #include fmgr.h

Re: [GENERAL] Recreate C functions?

2010-12-14 Thread Elliot Chance
2010/12/14 Elliot Chance elliotcha...@gmail.com: Hi, I seem to be having trouble recreating C functions, the source: === test.c #include postgres.h #include fmgr.h PG_MODULE_MAGIC; int32 plpgsql_test(text* s) { return 100; } === end === Then compile: $ cc -fpic -c -I/usr

Re: [GENERAL] Postgres forums ... take 2

2010-11-28 Thread Elliot Chance
: On 22 November 2010 14:05, Bruce Momjian br...@momjian.us wrote: Magnus Hagander wrote: On Sat, Nov 20, 2010 at 16:54, Bruce Momjian br...@momjian.us wrote: Elliot Chance wrote: Also, if someone registers on the forum, do they get a major domo registration email? ?And if so, would

Re: [GENERAL] The first dedicated PostgreSQL forum

2010-11-22 Thread Elliot Chance
On 22/11/2010, at 10:22 PM, Gurjeet Singh wrote: On Fri, Nov 19, 2010 at 1:07 AM, Thom Brown t...@linux.com wrote: As has been said previously, an unlinked forum (one which has no interaction with the mailing list) is destined to fail, as others have in the past. It's creates a fragmented

Fwd: [GENERAL] [pgsql-www] Forums at postgresql.com.au

2010-11-21 Thread Elliot Chance
On 21/11/2010, at 2:59 AM, Bruce Momjian wrote: Magnus Hagander wrote: On Sat, Nov 20, 2010 at 14:46, Elliot Chance elliotcha...@gmail.com wrote: for...@postgresql.com.au is pointed to a black hole so that email disappears but the mailing list gets another copy. When the mailing list gets

[GENERAL] Fwd: [pgsql-www] Forums at postgresql.com.au

2010-11-20 Thread Elliot Chance
On 20/11/2010, at 9:52 PM, Magnus Hagander wrote: On Sat, Nov 20, 2010 at 02:57, Elliot Chance elliotcha...@gmail.com wrote: On 20/11/2010, at 3:58 AM, Magnus Hagander wrote: On Fri, Nov 19, 2010 at 16:14, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Dave Page's

[GENERAL] Fwd: [pgsql-www] Forums at postgresql.com.au

2010-11-20 Thread Elliot Chance
in the forum system) -- this would solve Dave's concern.) That would solve it, yes. I don't think mj2 will allow that though - we've been looking for something similar for sysadmin use. So let's patch Mj2. If we use a pattern like the persons unique username: Elliot Chance forums-chan

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

2010-11-20 Thread Elliot Chance
On 20/11/2010, at 11:52 PM, Magnus Hagander wrote: On Sat, Nov 20, 2010 at 12:26, Elliot Chance elliotcha...@gmail.com wrote: On 20/11/2010, at 9:52 PM, Magnus Hagander wrote: On Sat, Nov 20, 2010 at 02:57, Elliot Chance elliotcha...@gmail.com wrote: On 20/11/2010, at 3:58 AM, Magnus

[GENERAL] Fwd: [pgsql-www] Forums at postgresql.com.au

2010-11-20 Thread Elliot Chance
Begin forwarded message: From: Magnus Hagander mag...@hagander.net Date: 20 November 2010 3:58:41 AM AEDT To: Alvaro Herrera alvhe...@commandprompt.com Cc: Dave Page dp...@pgadmin.org, Elliot Chance elliotcha...@gmail.com, pgsql-www pgsql-...@postgresql.org Subject: Re: [pgsql-www

Fwd: [GENERAL] The first dedicated PostgreSQL forum

2010-11-20 Thread Elliot Chance
Apple Mail has not been copying the mailing list, so excuse the reposts if you got one. Begin forwarded message: From: Elliot Chance elliotcha...@gmail.com Date: 19 November 2010 9:18:18 AM AEDT To: Daniel Verite dan...@manitou-mail.org Subject: Re: [GENERAL] The first dedicated PostgreSQL

Fwd: [GENERAL] Postgres forums ... take 2

2010-11-20 Thread Elliot Chance
Apple Mail has not been copying the mailing list, so excuse the reposts if you got one. Begin forwarded message: From: Elliot Chance elliotcha...@gmail.com Date: 15 November 2010 9:02:43 PM AEDT To: Thom Brown t...@linux.com Subject: Re: [GENERAL] Postgres forums ... take 2 On 15/11/2010

Fwd: [GENERAL] Postgres forums ... take 2

2010-11-20 Thread Elliot Chance
Apple Mail has not been copying the mailing list, so excuse the reposts if you got one. Begin forwarded message: From: Elliot Chance elliotcha...@gmail.com Date: 16 November 2010 4:57:27 PM AEDT To: Craig Ringer cr...@postnewspapers.com.au Subject: Re: [GENERAL] Postgres forums ... take 2

Re: [GENERAL] [pgsql-www] Forums at postgresql.com.au

2010-11-20 Thread Elliot Chance
Using the reply to all, thanks. On 21/11/2010, at 12:32 AM, Magnus Hagander wrote: On Sat, Nov 20, 2010 at 14:22, Elliot Chance elliotcha...@gmail.com wrote: On 20/11/2010, at 11:52 PM, Magnus Hagander wrote: On Sat, Nov 20, 2010 at 12:26, Elliot Chance elliotcha...@gmail.com wrote

Re: [GENERAL] Fwd: [pgsql-www] Forums at postgresql.com.au

2010-11-20 Thread Elliot Chance
On 21/11/2010, at 2:41 AM, Tom Lane wrote: Elliot Chance elliotcha...@gmail.com writes: Then I can create a catch-all so that when an email is sent to forums-chan...@postgresql.com.au it finds the user chancey gets the real address and sends it on. If there were a way we could register

Fwd: [GENERAL] The first dedicated PostgreSQL forum

2010-11-20 Thread Elliot Chance
Apple Mail has not been copying the mailing list, so excuse the reposts if you got one. Begin forwarded message: From: Elliot Chance elliotcha...@gmail.com Date: 14 November 2010 12:30:19 PM AEDT To: Tom Lane t...@sss.pgh.pa.us Subject: Re: [GENERAL] The first dedicated PostgreSQL forum

Re: [GENERAL] Postgres forums ... take 2

2010-11-17 Thread Elliot Chance
:15 PM, Magnus Hagander wrote: On Wed, Nov 17, 2010 at 00:00, Elliot Chance elliotcha...@gmail.com wrote: On 17/11/2010, at 6:22 AM, Stephen Cook wrote: On 11/16/2010 10:51 AM, Magnus Hagander wrote: What I'm more interested in is still a word from the people who would actually *use* a forum

Re: [GENERAL] Postgres forums ... take 2

2010-11-16 Thread Elliot Chance
Alrighty, here are the revised plans for beta3: --- Changes / Fixes * Without a doubt everyone one wants the forums to match the mailing lists. I personally think that this defeats the whole purpose of a forum, but i'm here to do what the community thinks is best. The extra forums that are not

Re: [GENERAL] Postgres forums ... take 2

2010-11-16 Thread Elliot Chance
On 17/11/2010, at 6:22 AM, Stephen Cook wrote: On 11/16/2010 10:51 AM, Magnus Hagander wrote: What I'm more interested in is still a word from the people who would actually *use* a forum on how this would be better than sites like Nabble and Gmane. I'm one of those. I'm subscribed to

[GENERAL] Postgres forums ... take 2

2010-11-15 Thread Elliot Chance
Hi again, I've taken in all the feedback about http://forums.postgresql.com.au and the general consensus is that nobody wants a separate entity - a few people mentioned that if it was interoperable with the mailing list that it would be better. So I did. The concept goes like this; 1. Any

Fwd: [GENERAL] Postgres forums ... take 2

2010-11-15 Thread Elliot Chance
On 15/11/2010, at 8:37 PM, Thom Brown wrote: On 15 November 2010 08:34, Elliot Chance elliotcha...@gmail.com wrote: Hi again, I've taken in all the feedback about http://forums.postgresql.com.au and the general consensus is that nobody wants a separate entity - a few people mentioned

Re: [GENERAL] Postgres forums ... take 2

2010-11-15 Thread Elliot Chance
forum mappings as needed, and I could add post processing. So for example an email to pgsql-general with the title perl won't connect will recognise perl and move it to the Languages Perl. On 15/11/2010, at 9:42 PM, Magnus Hagander wrote: On Mon, Nov 15, 2010 at 11:08, Elliot Chance elliotcha

Fwd: [GENERAL] Postgres forums ... take 2

2010-11-15 Thread Elliot Chance
On 16/11/2010, at 2:01 PM, Craig Ringer wrote: On 15/11/10 17:37, Thom Brown wrote: That's actually some good work you've done there! I didn't know phpBB supported bidirectional mailing list support. Yikes. Neither did I. I've always seen phpBB as the barren wasteland of web forums -

[GENERAL] The first dedicated PostgreSQL forum

2010-11-12 Thread Elliot Chance
Hi everyone, This is my first post on the mailing list :) As of today I have started the first dedicated postgres forum at: http://forums.postgresql.com.au I would much appreciate anyone that has the time to sign up and subscribe to some of the forums ready to answer incoming posts. Any