[Pgpool-general] automatic detection of SERIAL data type

Mon Dec 22 08:32:15 UTC 2008

On Sun, Dec 21, 2008 at 12:18 AM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> 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.

Nice work, Tatsuo. Thanks a lot for your time on the project!

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

Not my case, but I was wondering what if the reason was stuff such as
CURRENT_TIMESTAMP and those type of functions...

-- 
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"