Search Postgresql Archives

Re: What could cause a temp table to disappear?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 02/27/2013 01:48 PM, François Beausoleil wrote:

Le 2013-02-27 à 16:45, Adrian Klaver a écrit :

On 02/27/2013 01:19 PM, François Beausoleil wrote:


Any hints?

See in line notes below.
Also what client/library are you using to connect with?

I use Ruby & Sequel. Sequel is a very thin library over straight SQL.



This is the production log, and it's the exact same in dev. The data I'm
putting in the tables is authoritative, except for airings, which may or
may not already exist in the database. In dev, the INSERT INTO airings
SELECT * FROM airings_import WHERE NOT EXISTS(...) statement runs to
completion. That's why I'm puzzled.

Everything else is the same? It is acting like something is closing a session on you. Could there be a connection pooler in the mix?


Bye,
François


--
Adrian Klaver
adrian.klaver@xxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux