Re: Temp tables and copy - Mailing list pgsql-hackers

From Gavin Sherry
Subject Re: Temp tables and copy
Date
Msg-id Pine.LNX.4.21.0309101141120.21349-100000@linuxworld.com.au
Whole thread Raw
In response to Temp tables and copy  (Konstantin Goudkov <bcc@idftech.com>)
List pgsql-hackers
On Mon, 8 Sep 2003, Konstantin Goudkov wrote:

> 
> Hey guys, not sure if this is the right place to post.
> Not even sure if this is a bug or a feature :)
> 
> When I create a temp table and then try to copy some data into the
> table, if the data is corrupt and the synchronization is lost - the
> table also seems to get lost.

Temp tables only exist for the current session (connection). If there is a
problem with the copy and the connection gets reset, the session is
therefore ended and the temp table remove. As such it is a feature.

Gavin



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Unixware Patch (Was: Re: Beta2 Tag'd and Bundled ...)
Next
From: Gavin Sherry
Date:
Subject: Re: Can I use PostgreSQL to develop a self-organizing