Re: pg_restore and create FK without verification check

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_restore and create FK without verification check
Date: 2003-11-27 01:00:59
Message-ID: 3FC54CCB.9010809@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-11-27 02:27:22 7.5 Plans
Previous Message Joshua D. Drake 2003-11-27 00:04:42 Re: Limiting factors of pg_largeobject