diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-12-07 19:43:13 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-12-07 19:43:13 +0000 |
commit | f3bc5ae4521aa4acb4628a134183d2250e9ab040 (patch) | |
tree | 704663675681f6370bad21fb922c8c5ec8e8d9aa /src | |
parent | d5130d2387bc72fd35f061cb33b781d4dafa709c (diff) | |
download | postgresql-f3bc5ae4521aa4acb4628a134183d2250e9ab040.tar.gz postgresql-f3bc5ae4521aa4acb4628a134183d2250e9ab040.zip |
Remove test on c.relkind from check_constraints view; unnecessary and
prevents view from showing constraints on domains. This addresses the
other half of Claus Colloseus' bug report.
Diffstat (limited to 'src')
-rw-r--r-- | src/backend/catalog/information_schema.sql | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql index de86192f0ed..63783f39585 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.2 2003/12/07 10:18:50 petere Exp $ + * $Id: information_schema.sql,v 1.15.2.3 2003/12/07 19:43:13 tgl Exp $ */ /* @@ -112,8 +112,7 @@ CREATE VIEW check_constraints AS WHERE rs.oid = con.connamespace AND u.usesysid = coalesce(c.relowner, t.typowner) AND u.usename = current_user - AND con.contype = 'c' - AND c.relkind = 'r'; + AND con.contype = 'c'; GRANT SELECT ON check_constraints TO PUBLIC; |