Temp tables and copy
От | Konstantin Goudkov |
---|---|
Тема | Temp tables and copy |
Дата | |
Msg-id | bjlu93$10jk$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: Temp tables and copy
|
Список | 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@idftech.com
В списке pgsql-general по дате отправления: