Re: pl/proxy and sequence generation - Mailing list pgsql-general

From Jonah H. Harris
Subject Re: pl/proxy and sequence generation
Date
Msg-id 36e682920812240744s7067168dq2fdfe8095f15234a@mail.gmail.com
Whole thread Raw
In response to pl/proxy and sequence generation  (Igor Katson <descentspb@gmail.com>)
Responses Re: pl/proxy and sequence generation
List pgsql-general
On Wed, Dec 24, 2008 at 10:18 AM, Igor Katson <descentspb@gmail.com> wrote:
> So, should I make a wrapper in e.g. PL/pgsql for every insert function
> writen in PL/Proxy to remove the sequence from the argument list and to call
> the sequence generator?
> Is there a better way to do that?

Why not put the sequence on your main PL/Proxy hub and call the function with:

SELECT some_func(nextval('my_seq'), foo, bar, baz, ...);

--
Jonah H. Harris, Senior DBA
myYearbook.com

pgsql-general by date:

Previous
From: Igor Katson
Date:
Subject: pl/proxy and sequence generation
Next
From: Adrian Klaver
Date:
Subject: Re: need some help with pl-pgsql