Обсуждение: BUG #1895: SQLForeignKeys don't return the correct number of foreign keys

The following bug has been logged online:

Bug reference:      1895
Logged by:          Abel Pinto Muñoz
Email address:      apinto@ccs.biz
PostgreSQL version: 8.0.3 Build 103
Operating system:   Windows
Description:        SQLForeignKeys don't return the correct number of
foreign keys
Details:

We create 2 tables with 2 foreign keys:
CREATE TABLE ekon.T113355A
(PK INTEGER NOT NULL, PRIMARY KEY(PK))

CREATE TABLE ekon.T113355B
(PK INTEGER NOT NULL, F1 INTEGER, F2 INTEGER, PRIMARY KEY(PK))

ALTER TABLE ekon.T113355B ADD CONSTRAINT T113355B_A  FOREIGN KEY (F1)
REFERENCES ekon.T113355A(PK)

ALTER TABLE ekon.T113355B ADD CONSTRAINT T113355B_B  FOREIGN KEY (F2)
REFERENCES ekon.T113355A(PK)

Then we ask for the foreign keys (SQLForeignKeys) of table T113355A. The
number of results aren't two when we only create two foreign keys.

Also we test the beta version 8.1.4 and we obtain the same result.

Thanks