On 01/06/2012 01:11 PM, Phoenix Kiula wrote:
On Fri, Jan 6, 2012 at 11:46 AM, Tom Lane<[email protected]> wrote:
Phoenix Kiula<[email protected]> writes:
Hi. I'm using Postgresql 9.0.5, and the connection is made via pgbouncer.
Perhaps pgbouncer is redirecting the second command to a different
session?
Thanks Tom. I'm in the exact same session in my terminal, and the
commands are entered within 2 seconds of each other. With copy/paste,
maybe split microseconds of each other.
How can I make sure pgbouncer takes it all in the same session? I also
tried the two commands within a transaction.
Sounds like you are using statement pooling - every statement can be
assigned to a different server connection. You may need transaction
pooling or session pooling:
http://pgbouncer.projects.postgresql.org/doc/usage.html
Cheers,
Steve
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
