From f3bc5ae4521aa4acb4628a134183d2250e9ab040 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 7 Dec 2003 19:43:13 +0000 Subject: [PATCH] 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. --- src/backend/catalog/information_schema.sql | 5 ++--- 1 file 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; -- 2.39.5