Re: pg_restore and create FK without verification check

--- Andreas Pflug <pgadmin@pse-consulting.de> wrote:
> Stephan Szabo wrote:
> 
> >
> >
> >IIRC, he was. I think the thing causing the difference between his times
> >and the ones we saw typically when doing the tests was that he didn't have
> >an index on the fktable's referencing column.
> >  
> >
> 
> A common mistake, can't count how often I created this one...

Wrong. It's a mistake to think that you always HAVE to have an index on FK
column. See the links below for more details:

http://archives.postgresql.org/pgsql-admin/2003-11/msg00317.php
http://archives.postgresql.org/pgsql-admin/2003-11/msg00319.php




__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/