Skip site navigation (1) Skip section navigation (2)

Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)
Date: 2003-09-29 09:04:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-hackers
Christopher Kings-Lynne wrote:

> You could just as easily argue that the lack of integrity testing at 
> data load time was equally a bug.
> I think we need someway of telling postgres to suppress a foreign key 
> check.
> The main problem is that the foreign key column is often not indexed. 

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.


In response to


pgsql-hackers by date

Next:From: Andreas PflugDate: 2003-09-29 09:14:02
Subject: Re: pg_get_ruledef and extra line breaks
Previous:From: Peter EisentrautDate: 2003-09-29 08:07:57
Subject: Re: pg_dump no longer honors --no-reconnect

pgsql-general by date

Next:From: Bjørn T JohansenDate: 2003-09-29 09:11:55
Subject: Time problem again?
Previous:From: Gezeala 'Eyah' Bacuo IIDate: 2003-09-29 07:47:05
Subject: numeric rounding

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group