Commit4222491

committed

information_schema.constraint_column_usage and key_column_usage should

not discriminate against system columns, since we support constraints onsystem columns, and in fact constraints on OID are moderately useful.

1 parent78f637c commit4222491Copy full SHA for 4222491

File tree

-4

lines changed

-4

lines changed

Lines changed: 1 addition & 4 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.20 2003/12/16 14:57:20 petere Exp $`
	`7`	`+ * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.21 2003/12/17 22:11:30 tgl Exp $`
`8`	`8`	`*/`
`9`	`9`
`10`	`10`	`/*`
`@@ -434,7 +434,6 @@ CREATE VIEW constraint_column_usage AS`
`434`	`434`	`ANDc.connamespace=nc.oid`
`435`	`435`	`ANDc.contype='c'`
`436`	`436`	`ANDr.relkind='r'`
`437`		`-ANDa.attnum>0`
`438`	`437`	`AND NOTa.attisdropped`
`439`	`438`
`440`	`439`	`UNION ALL`
`@@ -448,7 +447,6 @@ CREATE VIEW constraint_column_usage AS`
`448`	`447`	`ANDnc.oid=c.connamespace`
`449`	`448`	`AND (CASE WHENc.contype='f' THENr.oid=c.confrelidANDc.confkey[pos.n]=a.attnum`
`450`	`449`	`ELSEr.oid=c.conrelidANDc.conkey[pos.n]=a.attnum END)`
`451`		`-ANDa.attnum>0`
`452`	`450`	`AND NOTa.attisdropped`
`453`	`451`	`ANDc.contypeIN ('p','u','f')`
`454`	`452`	`ANDr.relkind='r'`
`@@ -683,7 +681,6 @@ CREATE VIEW key_column_usage AS`
`683`	`681`	`ANDr.oid=c.conrelid`
`684`	`682`	`ANDnc.oid=c.connamespace`
`685`	`683`	`ANDc.conkey[pos.n]=a.attnum`
`686`		`-ANDa.attnum>0`
`687`	`684`	`AND NOTa.attisdropped`
`688`	`685`	`ANDc.contypeIN ('p','u','f')`
`689`	`686`	`ANDr.relkind='r'`

Comments

(0)