Re: [HACKERS] Foreign keys in pg_dump

2002-09-06 Thread Rod Taylor
On Fri, 2002-09-06 at 01:19, Christopher Kings-Lynne wrote: > OK, > > The argument about using ALTER TABLE/ADD FOREIGN KEY in dumps was that it > caused an actual check of the data in the table, right? This was going to > be much slower than using CREATE CONSTRAINT TRIGGER. > > So, why can't we

[HACKERS] Foreign keys in pg_dump

2002-09-05 Thread Christopher Kings-Lynne
OK, The argument about using ALTER TABLE/ADD FOREIGN KEY in dumps was that it caused an actual check of the data in the table, right? This was going to be much slower than using CREATE CONSTRAINT TRIGGER. So, why can't we do this in the SQL that pg_dump creates (TODO): CREATE TABLE ... ALTER T