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: 3F77F5A6.6070107@pse-consulting.de (view raw or flat)
Thread:
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.

Regards,
Andreas



In response to

Responses

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-2014 The PostgreSQL Global Development Group