[Pgpool-general] Using SELECT + nextval + load balance with pgpool

[Devrim GUNDUZ]

Hello,

I think we have a problem with pgpool.

Environment: pgpool+2 PostgreSQL Servers + load balancing and
replication enabled.

Case: The application runs nextval to get the next id of the sequence.
Since this is a SELECT query, pgpool tries to send this query to only 1
server. Then, the application runs INSERT; however this results with
failure since the values of the sequences do not match between two
PostgreSQL servers.

I think this is not an application-leve bug; but it is a bug of pgpool.
pgpool must ignore load balancing if the query includes nextval or
setval.

Comments? Tatsuo, can you patch this?

Regards,
-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20060906/60eafad3/attachment.bin