Postgres Pro
Downloads
Home   >   mailing lists

BUG #1895: SQLForeignKeys don't return the correct number of foreign keys - Mailing list pgsql-bugs

From Abel Pinto Muñoz
Subject BUG #1895: SQLForeignKeys don't return the correct number of foreign keys
Date
Msg-id 20050919141035.029A7F0BDC@svr2.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: "Daniel Naschenweng"
Date:
Subject: BUG #1892: pg_dumpall get five passwords
Next
From: "Gerhard Kirchmann"
Date:
Subject: BUG #1894: postmaster does not start