Re: pg_restore and create FK without verification check

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