Re: pg_restore and create FK without verification check - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: pg_restore and create FK without verification check
Date
Msg-id 3FC54CCB.9010809@familyhealth.com.au
Whole thread Raw
In response to Re: pg_restore and create FK without verification check  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-hackers
> A common mistake, can't count how often I created this one... And not 
> easy to find, because EXPLAIN won't explain triggers.
> I'm planning to create some kind of fk index wizard in pgAdmin3, which 
> finds out about fks using columns that aren't covered by an appropriate 
> index. Maybe this check could be performed (as a NOTICE) when the fk is 
> created?

Weird - I'm planning the exact same thing for phpPgAdmin!

Great minds think alike :P

Chris




pgsql-hackers by date:

Previous
From: ow
Date:
Subject: Re: pg_restore and create FK without verification check
Next
From: Christopher Kings-Lynne
Date:
Subject: 7.5 Plans