| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bjørn T Johansen | 2003-09-29 09:11:55 | Time problem again? |
| Previous Message | Gezeala 'Eyah' Bacuo II | 2003-09-29 07:47:05 | numeric rounding |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Pflug | 2003-09-29 09:14:02 | Re: pg_get_ruledef and extra line breaks |
| Previous Message | Peter Eisentraut | 2003-09-29 08:07:57 | Re: pg_dump no longer honors --no-reconnect |