Re: URGENT: temporary table not recognized? - Mailing list pgsql-general

From Phoenix Kiula
Subject Re: URGENT: temporary table not recognized?
Date
Msg-id CAFWfU=tkqa-WFmmgizbbLDFzB4A7xC7TqM2j+W0673=ySTOqqw@mail.gmail.com
Whole thread Raw
In response to Re: URGENT: temporary table not recognized?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: URGENT: temporary table not recognized?
List pgsql-general
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.

pgsql-general by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: please help understand freeing shared buffers
Next
From: Tom Lane
Date:
Subject: Re: please help understand freeing shared buffers