Temp tables and copy

[Konstantin Goudkov]

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.

For example
create temp table words(aa varchar(254));
copy words from stdin;
some stuff
more stuff
corrupt line\tline\tline
more\tstuff
and yet more stuff
\.

(replace ''\t'' with the real tabs to break the synchronization)

after that,

select * from words;
ERROR: Relation "words" does not exist

Running:
> Welcome to psql 7.3.4, the PostgreSQL interactive terminal.
on
> FreeBSD dev1.idftech.com 4.6-RELEASE FreeBSD 4.6-RELEASE #2: Sun Jun 8 04:57:54 EDT 2003

Konstantin Goudkov
IDF Technologies, LLC.
b...@idftech.com

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majo...@postgresql.org so that your
message can get through to the mailing list cleanly

[Gavin Sherry]

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster