On Fri, Jan 6, 2012 at 11:24 PM, Steve Crawford
<scrawford@pinpointresearch.com> wrote:
> On 01/06/2012 01:11 PM, Phoenix Kiula wrote:
>>
>> On Fri, Jan 6, 2012 at 11:46 AM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
>>>
>>> Phoenix Kiula<phoenix.kiula@gmail.com> 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
