> Please fix and resubmit soon. Attached version should now work properly.
-- Greg Sabino Mullane [EMAIL PROTECTED] End Point Corporation PGP Key: 0x14964AC8 200609041803 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
Index: information_schema.sql
===================================================================
RCS file: /projects/cvsroot/pgsql/src/backend/catalog/information_schema.sql,v
retrieving revision 1.34
diff -c -r1.34 information_schema.sql
*** information_schema.sql 4 Sep 2006 21:03:18 -0000 1.34
--- information_schema.sql 4 Sep 2006 22:00:33 -0000
***************
*** 921,931 ****
CAST(relname AS sql_identifier) AS table_name,
CAST(a.attname AS sql_identifier) AS column_name,
CAST((ss.x).n AS cardinal_number) AS ordinal_position,
! CAST(null AS cardinal_number) AS position_in_unique_constraint -- FIXME
FROM pg_attribute a,
! (SELECT r.oid, nc.nspname AS nc_nspname, c.conname,
nr.nspname AS nr_nspname, r.relname,
! _pg_expandarray(c.conkey) AS x
FROM pg_namespace nr, pg_class r, pg_namespace nc,
pg_constraint c
WHERE nr.oid = r.relnamespace
--- 921,937 ----
CAST(relname AS sql_identifier) AS table_name,
CAST(a.attname AS sql_identifier) AS column_name,
CAST((ss.x).n AS cardinal_number) AS ordinal_position,
! (
! SELECT CAST(a AS cardinal_number)
! FROM pg_constraint,
! (SELECT a FROM generate_series(1,(SELECT array_upper(ss.confkey,1))) f(a)) AS foo
! WHERE conrelid = ss.confrelid
! AND conkey[foo.a] = ss.confkey[(ss.x).n]
! ) AS position_in_unique_constraint
FROM pg_attribute a,
! (SELECT r.oid, nc.nspname AS nc_nspname, c.conname, c.confkey, c.confrelid,
nr.nspname AS nr_nspname, r.relname,
! _pg_expandarray(c.conkey) AS x
FROM pg_namespace nr, pg_class r, pg_namespace nc,
pg_constraint c
WHERE nr.oid = r.relnamespace
signature.asc
Description: This is a digitally signed message part
