On Wed, 2003-11-26 at 12:43, Andreas Pflug wrote: > Greg Stark wrote: > > >If I could disable and reenable the constraint the danger that I would get the > >definition wrong would be eliminated. And if I had already done the work to > >ensure there were no broken relationships I would optionally be able to skip > >the redundant automatic check. I could even have done the verification myself > >while the data wasn't live for example. > > > > > > Since FKs are implemented as trigger, you could disable all triggers on > the table right now, no? Could be a bit more comfortable, I agree, and > hope for an upcoming DISABLE TRIGGER command.
ISTM I've done this before... from a pg_dump -Fc backup first do a pg_dump -s restore (schema only) and then a pg_dump -a --disable-triggers to load the data without check foreign keys. Theres certainly potential for trouble with this method I suppose but it seems like it accomplish what the original poster requires... Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]