Re: URGENT: temporary table not recognized?
| От | Marko Kreen |
|---|---|
| Тема | Re: URGENT: temporary table not recognized? |
| Дата | |
| Msg-id | CACMqXCLr4vjtFMS8f3=VO3pywjgbY4NSPCqnfSj9MqYXmG-nBQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: URGENT: temporary table not recognized? (Steve Crawford <scrawford@pinpointresearch.com>) |
| Ответы |
Re: URGENT: temporary table not recognized?
|
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: