From 0b00d7cd4a1e94b08ceeb5d1c8015cff557946ed Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Tue, 16 Dec 2003 14:56:34 +0000 Subject: [PATCH] Fix constraint_column_usage for foreign keys. --- src/backend/catalog/information_schema.sql | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql index 63783f3958..64807ff6bb 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.3 2003/12/07 19:43:13 tgl Exp $ + * $Id: information_schema.sql,v 1.15.2.4 2003/12/16 14:56:34 petere Exp $ */ /* @@ -445,10 +445,9 @@ CREATE VIEW constraint_column_usage AS pg_constraint c, _pg_keypositions() AS pos(n) WHERE nr.oid = r.relnamespace AND r.oid = a.attrelid - AND r.oid = c.conrelid AND nc.oid = c.connamespace - AND (CASE WHEN c.contype = 'f' THEN c.confkey[pos.n] = a.attnum - ELSE c.conkey[pos.n] = a.attnum END) + AND (CASE WHEN c.contype = 'f' THEN r.oid = c.confrelid AND c.confkey[pos.n] = a.attnum + ELSE r.oid = c.conrelid AND c.conkey[pos.n] = a.attnum END) AND a.attnum > 0 AND NOT a.attisdropped AND c.contype IN ('p', 'u', 'f') -- 2.50.0