[Pgpool-general] handling of sequences

Josh Berkus josh at agliodbs.com
Tue Mar 2 00:57:22 UTC 2010


On 3/1/10 4:50 PM, Tatsuo Ishii wrote:
>> To really handle serials, all sequences would need to come from a
>> designated server.  I think that would be the simplest solution.  You
>> could fairly easily capture nextval(), setval() etc., but capturing the
>> implied ID for a table where nextval() wasn't called explicitly would be
>> much more challenging.
> 
> I assume you are talking about tables having SERIAL column. We already
> have such that technology for TIMESTAMP rewriting and should be no
> problem.

OK, great.  Not that I can work on it right now, but seems straightforwards.

--Josh Berkus


More information about the Pgpool-general mailing list