| From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta) |
| Date: | 2003-09-29 11:47:11 |
| Message-ID: | Pine.LNX.4.21.0309291245440.525-100000@ponder.fairway2k.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Mon, 29 Sep 2003, Christopher Kings-Lynne wrote:
> > 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!
That's only partially determinable though. The trigger code could branch and
run two different queries depending on the values supplied in the 'input' tuple
of the trigger.
Nigel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bjørn T Johansen | 2003-09-29 11:47:36 | Re: Time problem again? |
| Previous Message | Daniel Schuchardt | 2003-09-29 11:44:48 | Re: Time problem again? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2003-09-29 12:23:26 | Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta) |
| Previous Message | Hiroshi Inoue | 2003-09-29 10:51:35 | Re: pgsql-server/src/backend catalog/index.c comma ... |