]> granicus.if.org Git - postgresql/commit
Subject: Bug in SQLForeignKeys()
authorBruce Momjian <bruce@momjian.us>
Tue, 23 Jan 2001 20:36:30 +0000 (20:36 +0000)
committerBruce Momjian <bruce@momjian.us>
Tue, 23 Jan 2001 20:36:30 +0000 (20:36 +0000)
commitedfca4b98b44f336ca88b2adf4dfbe6b59d7b146
tree2bcc7fa39bf826c07fbd978c21f813289d8f1f17
parent3de8407ea7d3c6d3343242ed72cefd4a51373861
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
src/interfaces/odbc/info.c
src/interfaces/odbc/pgtypes.c