Re: [GENERAL] COPY data and referential triggers ...

2004-10-23 Thread Tom Lane
James Robinson <[EMAIL PROTECTED]> writes: > Just a sanity check -- data fed into pg using the > COPY tablename (col1, col2) FROM stdin; > ... data > \. > Does not cause referential triggers to fire (i.e. foreign keys), right? Sure it does. regression=# create table t1 (f1 int

[GENERAL] COPY data and referential triggers ...

2004-10-23 Thread James Robinson
Just a sanity check -- data fed into pg using the COPY tablename (col1, col2) FROM stdin; ... data \. Does not cause referential triggers to fire (i.e. foreign keys), right? It seems to operate this way, yet I didn't see this mentioned explicitly in the SQL reference manua