diff options
| -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 9c651f9c0f3..db4d79f6de5 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.20 2003/12/16 14:57:20 petere Exp $ + * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.21 2003/12/17 22:11:30 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' |