[Pgpool-general] handling of sequences

Tatsuo Ishii ishii at sraoss.co.jp
Tue Mar 2 00:50:09 UTC 2010


> 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.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the Pgpool-general mailing list