[Pgpool-general] handling of sequences

[Tatsuo Ishii]

> Tatsuo,
> 
> The official docs in English reccommend the use of insert_lock for
> tables containing SERIAL columns, which is obviously an issue for
> performance and a potential source of deadlocks.

You could always turn off the directive.

> Browsing through the source code, though, I see some rewrite code for
> SERIALs; that doesn't work to rewrite serials so that you don't need
> insert_lock?  Is this something you're working on?

Which part of the code are referring to? In my understanding there's
no SERIAL rewriting code today. Though I would like to have more
complete SERIAL support which may involves SERIAL rewriting.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp