On Fri, Jan 6, 2012 at 11:24 PM, Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> wrote: > 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 Statement pooling throws error on open transaction. -- marko -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
