Temp tables and copy

From: Konstantin Goudkov <bcc(at)idftech(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Temp tables and copy
Date: 2003-09-08 16:58:20
Message-ID: 15644951124.20030908125820@idftech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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.
bcc(at)idftech(dot)com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Darko Prenosil 2003-09-08 16:58:23 Re: pgsql vc++|win32
Previous Message Andreas Pflug 2003-09-08 16:57:06 Re: plpgsql doesn't coerce boolean expressions to boolean