Re: URGENT: temporary table not recognized?

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: URGENT: temporary table not recognized?
Date: 2012-01-06 21:11:38
Message-ID: CAFWfU=tkqa-WFmmgizbbLDFzB4A7xC7TqM2j+W0673=ySTOqqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jan 6, 2012 at 11:46 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-01-06 21:24:03 Re: please help understand freeing shared buffers
Previous Message Filip Rembiałkowski 2012-01-06 20:24:51 please help understand freeing shared buffers