aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2003-12-07 19:43:13 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2003-12-07 19:43:13 +0000
commitf3bc5ae4521aa4acb4628a134183d2250e9ab040 (patch)
tree704663675681f6370bad21fb922c8c5ec8e8d9aa /src
parentd5130d2387bc72fd35f061cb33b781d4dafa709c (diff)
downloadpostgresql-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.sql5
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;