Postgres Pro
Downloads
Home   >   mailing lists

Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta) - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)
Date
Msg-id 3F77F9A3.8000808@familyhealth.com.au
Whole thread Raw
In response to Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)  (Andreas Pflug <pgadmin@pse-consulting.de>)
Responses Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-hackers
Tree view 
> So a db designer made a bloody mistake.
> The problem is there's no easy way to find out what's missing.
> I'd really like EXPLAIN to display all subsequent triggered queries 
> also, to see the full scans caused by missing indexes.

I'd sure second that!

Chris

pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: pg_get_ruledef and extra line breaks
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: pg_get_ruledef and extra line breaks