BUG #1895: SQLForeignKeys don't return the correct number of foreign keys

From: "Abel Pinto Muoz" <apinto(at)ccs(dot)biz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1895: SQLForeignKeys don't return the correct number of foreign keys
Date: 2005-09-19 14:10:35
Message-ID: 20050919141035.029A7F0BDC@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1895
Logged by: Abel Pinto Muoz
Email address: apinto(at)ccs(dot)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

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-09-19 15:25:19 Re: BUG #1893: pg_dumpall - Search path order
Previous Message Gerhard Kirchmann 2005-09-19 13:37:42 BUG #1894: postmaster does not start