| From: | Bruce Momjian - CVS <momjian(at)hub(dot)org> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql/src/interfaces/odbc info.c pgtypes.c |
| Date: | 2001-01-23 20:36:31 |
| Message-ID: | 200101232036.f0NKaVI18559@hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
CVSROOT: /home/projects/pgsql/cvsroot
Module name: pgsql
Changes by: momjian(at)hub(dot)org 01/01/23 15:36:30
Modified files:
src/interfaces/odbc: info.c pgtypes.c
Log message:
Subject: Bug in SQLForeignKeys()
Query used for checking foreign key triggers
returns too many results when there're more than one foreign
key in a table. It happens because only table's oid is used to
link between pg_trigger with INSERT check and pg_trigger with
UPDATE/DELETE check.
I think there should be enough to add following conditions
into WHERE clause of that query:
AND pt.tgconstrname = pg_trigger.tgconstrname
AND pt.tgconstrname = pg_trigger_1.tgconstrname
/Constantin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-01-23 22:39:09 | pgsql/src/backend/parser gram.y |
| Previous Message | Peter Eisentraut - PostgreSQL | 2001-01-23 20:33:30 | pgsql/src/backend/utils/init globals.c |