|
4 | 4 | * |
5 | 5 | * Copyright 2003, PostgreSQL Global Development Group |
6 | 6 | * |
7 | | - * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.19 2003/12/07 19:43:02 tgl Exp $ |
| 7 | + * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.20 2003/12/16 14:57:20 petere Exp $ |
8 | 8 | */ |
9 | 9 |
|
10 | 10 | /* |
@@ -445,10 +445,9 @@ CREATE VIEW constraint_column_usage AS |
445 | 445 | pg_constraint c, _pg_keypositions()AS pos(n) |
446 | 446 | WHEREnr.oid=r.relnamespace |
447 | 447 | ANDr.oid=a.attrelid |
448 | | -ANDr.oid=c.conrelid |
449 | 448 | ANDnc.oid=c.connamespace |
450 | | -AND (CASE WHENc.contype='f' THENc.confkey[pos.n]=a.attnum |
451 | | - ELSEc.conkey[pos.n]=a.attnum END) |
| 449 | +AND (CASE WHENc.contype='f' THENr.oid=c.confrelidANDc.confkey[pos.n]=a.attnum |
| 450 | + ELSEr.oid=c.conrelidANDc.conkey[pos.n]=a.attnum END) |
452 | 451 | ANDa.attnum>0 |
453 | 452 | AND NOTa.attisdropped |
454 | 453 | ANDc.contypeIN ('p','u','f') |
|