Re: What could cause a temp table to disappear? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: What could cause a temp table to disappear?
Date
Msg-id 512E807D.3080408@gmail.com
Whole thread Raw
In response to Re: What could cause a temp table to disappear?  (François Beausoleil <francois@teksol.info>)
Responses Re: What could cause a temp table to disappear?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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@gmail.com

pgsql-general by date:

Previous
From: François Beausoleil
Date:
Subject: Re: What could cause a temp table to disappear?
Next
From: Tom Lane
Date:
Subject: Re: What could cause a temp table to disappear?