On 01/06/2012 01:11 PM, Phoenix Kiula wrote:
On Fri, Jan 6, 2012 at 11:46 AM, Tom Lane<tgl@xxxxxxxxxxxxx> wrote:
Phoenix Kiula<phoenix.kiula@xxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
