Marko Kreen <markokr@xxxxxxxxx> writes: > On Fri, Jan 6, 2012 at 11:24 PM, Steve Crawford > <scrawford@xxxxxxxxxxxxxxxxxxxx> wrote: >> On 01/06/2012 01:11 PM, Phoenix Kiula wrote: >>> 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. Yeah, if it still fails within a single transaction, it gets harder to blame pgbouncer. But there are not very many other candidates. I wondered about a funny setting of search_path, but ISTM that could at worst result in copying into the wrong table (ie some other table named "vl"), not failure to find any "vl" at all. It might be worth turning on statement logging and ensuring that log_line_prefix includes the process PID. Then the postmaster log would provide indisputable evidence whether the CREATE and the COPY are executed in the same session or not. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
