The following bug has been logged online: Bug reference: 1895 Logged by: Abel Pinto Muñoz Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
