Re: COPY seems to work, but no data in the table

Tom Lane wrote:
> ERROR: $1 referential integrity violation - key referenced from bar
> not found in foo
> lost synchronization with server, resetting connection
> regression=#
>
> I believe it works the same way in 7.2.1, but don't have an
> exactly-7.2.1-release code tree handy to check. (This is a post-7.2
> bug fix though, 7.2 will fail :-()

I do:

test=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

test=# create table foo(f1 int primary key);
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'foo_pkey' for table 'foo'
CREATE
test=# create table bar(f2 int references foo);
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
CREATE
test=# copy bar from stdin;
Enter data to be copied followed by a newline.
End with a backslash and a period on a line by itself.
>> 1
>> \.
ERROR: <unnamed> referential integrity violation - key referenced from
bar not found in foo
lost synchronization with server, resetting connection

Same result.

Joe