From: | "Konstantin Goudkov" <bcc-ng(at)idftech(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Temp tables and copy |
Date: | 2003-09-10 01:22:34 |
Message-ID: | bjlu93$10jk$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I posted it to the pgsql-hackers list, but I did not seem to get through.
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
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2003-09-10 01:40:09 | Re: Help needed in Replicating pgsql |
Previous Message | --CELKO-- | 2003-09-10 01:18:39 | Re: Find overlapping time intervals, how? |