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 |