diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-12-17 22:11:42 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-12-17 22:11:42 +0000 |
| commit | 1e2883a11545d780426e7e469c5909dbd339a6d1 (patch) | |
| tree | f13f4783d376f1815ac5b08fd3cdcf4910dceed8 /src | |
| parent | 1ba505dce1c3946818e6018ebad530cd1c39833d (diff) | |
| download | postgresql-1e2883a11545d780426e7e469c5909dbd339a6d1.tar.gz postgresql-1e2883a11545d780426e7e469c5909dbd339a6d1.zip | |
information_schema.constraint_column_usage and key_column_usage should
not discriminate against system columns, since we support constraints on
system columns, and in fact constraints on OID are moderately useful.
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/catalog/information_schema.sql | 5 |
1 files changed, 1 insertions, 4 deletions
diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql index 64807ff6bbe..d859445a0c8 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 * - * $Id: information_schema.sql,v 1.15.2.4 2003/12/16 14:56:34 petere Exp $ + * $Id: information_schema.sql,v 1.15.2.5 2003/12/17 22:11:42 tgl Exp $ */ /* @@ -434,7 +434,6 @@ CREATE VIEW constraint_column_usage AS AND c.connamespace = nc.oid AND c.contype = 'c' AND r.relkind = 'r' - AND a.attnum > 0 AND NOT a.attisdropped UNION ALL @@ -448,7 +447,6 @@ CREATE VIEW constraint_column_usage AS AND nc.oid = c.connamespace 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') AND r.relkind = 'r' @@ -683,7 +681,6 @@ CREATE VIEW key_column_usage AS AND r.oid = c.conrelid AND nc.oid = c.connamespace AND c.conkey[pos.n] = a.attnum - AND a.attnum > 0 AND NOT a.attisdropped AND c.contype IN ('p', 'u', 'f') AND r.relkind = 'r' |