[Pgpool-general] automatic detection of SERIAL data type

Tatsuo Ishii ishii at sraoss.co.jp
Sat Dec 20 23:18:31 UTC 2008


Hi,

I have committed changes to automatically detect if SERIAL data type
is used or not. If used(checking the system catalog in master), the
table is automatically locked while inserting data if insert_lock is
specified. 

Until now, if insert_lock is specified, the table is locked
unconditionaly while inserting data, which causes unnecssary locks
thus leads to performance loss.

So I think there's no need to set the default of insert_lock to be
false, and I have changed it to true.

In summary, now pgpool-II transparently (for client's point of view)
handles SERIAL data type, which is a long awaited feature since pgpool
was born.
--
Tatsuo Ishii
SRA OSS, Inc. Japan


More information about the Pgpool-general mailing list