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 sc
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 sc
On 31/12/2010, at 12:43 AM, Carlos Mennens wrote:
> On Mon, Dec 20, 2010 at 7:26 PM, Thom Brown 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 continue t
Sorry folks, this is an old message I forgot to copy pgsql-general on.
Begin forwarded message:
> From: Elliot Chance
> Date: 21 December 2010 11:48:07 AM AEDT
> To: Thom Brown
> Subject: Re: [GENERAL] Postgres forums ... take 2
>
> On 21/12/2010, at 11:26 AM, Thom Brown
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 mailing
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 t
f 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/ser
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
3. #include
4. #include
5.
6. #ifdef
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
> I'm trying
I'm trying to link up a C++ project with postgres functions, the following code
compiles (as C++):
extern "C" {
#include
#include
#ifdef PG_MODULE_MAGIC
PG_MODULE_MAGIC;
#endif
};
extern "C" {
PG_FUNCTION_INFO_V1(pg_xversion);
};
extern "C" Datu
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 check
etter to use V1 interface.
>
> Regards
>
> Pavel Stehule
>
> 2010/12/14 Elliot Chance :
>> Hi,
>>
>> I seem to be having trouble recreating C functions, the source:
>>
>> === test.c
>> #include
>> #include
>>
>>
es a way to tell it to refresh 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 :
>> Hi,
>>
>> I seem to be having trouble recreating C
Hi,
I seem to be having trouble recreating C functions, the source:
=== test.c
#include
#include
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
Then create the f
:
> On 22 November 2010 14:05, Bruce Momjian wrote:
>> Magnus Hagander wrote:
>>> On Sat, Nov 20, 2010 at 16:54, Bruce Momjian wrote:
>>>> Elliot Chance wrote:
>>>>>> Also, if someone registers on the forum, do they get a major domo
>>>
On 22/11/2010, at 10:22 PM, Gurjeet Singh wrote:
> On Fri, Nov 19, 2010 at 1:07 AM, Thom Brown 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 community
On 21/11/2010, at 2:59 AM, Bruce Momjian wrote:
> Magnus Hagander wrote:
>> On Sat, Nov 20, 2010 at 14:46, Elliot Chance wrote:
>>>>> for...@postgresql.com.au is pointed to a black hole so that email
>>>>> disappears but the mailing list gets another copy
Apple Mail has not been copying the mailing list, so excuse the reposts if you
got one.
Begin forwarded message:
> From: Elliot Chance
> Date: 14 November 2010 12:30:19 PM AEDT
> To: Tom Lane
> Subject: Re: [GENERAL] The first dedicated PostgreSQL forum
>
>
> On 14/11/
On 21/11/2010, at 2:41 AM, Tom Lane wrote:
> Elliot Chance 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 wa
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 wrote:
>>
>> On 20/11/2010, at 11:52 PM, Magnus Hagander wrote:
>>
>>> On Sat, Nov 20, 2010 at 12:26, Elliot Chance wrote:
>&g
Apple Mail has not been copying the mailing list, so excuse the reposts if you
got one.
Begin forwarded message:
> From: Elliot Chance
> Date: 16 November 2010 4:57:27 PM AEDT
> To: Craig Ringer
> Subject: Re: [GENERAL] Postgres forums ... take 2
>
> On 16/11/2010, at 2:0
Apple Mail has not been copying the mailing list, so excuse the reposts if you
got one.
Begin forwarded message:
> From: Elliot Chance
> Date: 15 November 2010 9:02:43 PM AEDT
> To: Thom Brown
> Subject: Re: [GENERAL] Postgres forums ... take 2
>
> On 15/11/2010, at 8:37 PM
Apple Mail has not been copying the mailing list, so excuse the reposts if you
got one.
Begin forwarded message:
> From: Elliot Chance
> Date: 19 November 2010 9:18:18 AM AEDT
> To: Daniel Verite
> Subject: Re: [GENERAL] The first dedicated PostgreSQL forum
>
> Is nobody
Begin forwarded message:
> From: Magnus Hagander
> Date: 20 November 2010 3:58:41 AM AEDT
> To: Alvaro Herrera
> Cc: Dave Page , Elliot Chance ,
> pgsql-www
> Subject: Re: [pgsql-www] Forums at postgresql.com.au
>
> On Fri, Nov 19, 2010 at 16:14, Alvaro Herrera
&g
On 20/11/2010, at 11:52 PM, Magnus Hagander wrote:
> On Sat, Nov 20, 2010 at 12:26, Elliot Chance wrote:
>>
>> On 20/11/2010, at 9:52 PM, Magnus Hagander wrote:
>>
>>> On Sat, Nov 20, 2010 at 02:57, Elliot Chance wrote:
>>>>
>>>
o the user when sent to
>>> that address (or maybe a PM 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 sysadmi
On 20/11/2010, at 9:52 PM, Magnus Hagander wrote:
> On Sat, Nov 20, 2010 at 02:57, Elliot Chance wrote:
>>
>> On 20/11/2010, at 3:58 AM, Magnus Hagander wrote:
>>
>> On Fri, Nov 19, 2010 at 16:14, Alvaro Herrera
>> wrote:
>>
>> Excerpts from Dav
nfo.php
This will make more sense if your able to help test.
On 17/11/2010, at 8:15 PM, Magnus Hagander wrote:
> On Wed, Nov 17, 2010 at 00:00, Elliot Chance wrote:
>>
>> On 17/11/2010, at 6:22 AM, Stephen Cook wrote:
>>
>>> On 11/16/2010 10:51 AM, Magnus Hagande
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
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
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 for
sql-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 wrote:
>> On 15/11/2010, at 8:37 PM, Thom Brown wro
On 15/11/2010, at 8:37 PM, Thom Brown wrote:
> On 15 November 2010 08:34, Elliot Chance 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
> m
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 post
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 feedba
35 matches
Mail list logo
