[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