Commit80af69c

committed

Remove test on c.relkind from check_constraints view; unnecessary and

prevents view from showing constraints on domains. This addresses theother half of Claus Colloseus' bug report.

1 parentd9d72bc commit80af69cCopy full SHA for 80af69c

File tree

-3

lines changed

-3

lines changed

Lines changed: 2 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -4,7 +4,7 @@`
`4`	`4`	`*`
`5`	`5`	`* Copyright 2003, PostgreSQL Global Development Group`
`6`	`6`	`*`
`7`		`- * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.18 2003/12/0710:21:58 petere Exp $`
	`7`	`+ * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.19 2003/12/0719:43:02 tgl Exp $`
`8`	`8`	`*/`
`9`	`9`
`10`	`10`	`/*`
`@@ -112,8 +112,7 @@ CREATE VIEW check_constraints AS`
`112`	`112`	`WHERErs.oid=con.connamespace`
`113`	`113`	`ANDu.usesysid= coalesce(c.relowner,t.typowner)`
`114`	`114`	`ANDu.usename=current_user`
`115`		`-ANDcon.contype='c'`
`116`		`-ANDc.relkind='r';`
	`115`	`+ANDcon.contype='c';`
`117`	`116`
`118`	`117`	`GRANTSELECTON check_constraints TO PUBLIC;`
`119`	`118`

Comments

(0)