diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2003-12-16 14:57:20 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2003-12-16 14:57:20 +0000 |
| commit | 0fb3ec1a58c25a454bcef3de43beaae092c2c7a3 (patch) | |
| tree | bf088086dbacfcd05e81acbd5b7d1e7714ecbcfd | |
| parent | f57832f6466bab8ad600d98fc8d4991e36c8bcdd (diff) | |
| download | postgresql-0fb3ec1a58c25a454bcef3de43beaae092c2c7a3.tar.gz postgresql-0fb3ec1a58c25a454bcef3de43beaae092c2c7a3.zip | |
Fix constraint_column_usage for foreign keys.
| -rw-r--r-- | src/backend/catalog/information_schema.sql | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql index c83565d496b..9c651f9c0f3 100644 --- a/src/backend/catalog/information_schema.sql +++ b/src/backend/catalog/information_schema.sql @@ -4,7 +4,7 @@ * * Copyright 2003, PostgreSQL Global Development Group * - * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.19 2003/12/07 19:43:02 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.20 2003/12/16 14:57:20 petere Exp $ */ /* @@ -445,10 +445,9 @@ CREATE VIEW constraint_column_usage AS pg_constraint c, _pg_keypositions() AS pos(n) WHERE nr.oid = r.relnamespace AND r.oid = a.attrelid - AND r.oid = c.conrelid AND nc.oid = c.connamespace - AND (CASE WHEN c.contype = 'f' THEN c.confkey[pos.n] = a.attnum - ELSE c.conkey[pos.n] = a.attnum END) + AND (CASE WHEN c.contype = 'f' THEN r.oid = c.confrelid AND c.confkey[pos.n] = a.attnum + ELSE r.oid = c.conrelid AND c.conkey[pos.n] = a.attnum END) AND a.attnum > 0 AND NOT a.attisdropped AND c.contype IN ('p', 'u', 'f') |