|
but with postgresql-8.3.1, ***t1.tgargs*** values
are empty – I meant sorry about the typo. -Suma From:
pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of We are upgrading our system from postgresql-8.2.0 to
postgresql-8.3.1. With postgresql-8.2.0, SELECT c1.relname as
PKTABLE_NAME, c2.relname as
FKTABLE_NAME,
t1.tgconstrname, a.attnum as
keyseq, ic.relname as
fkeyname, t1.tgdeferrable,
t1.tginitdeferred,
t1.tgnargs, t1.tgargs FROM
pg_catalog.pg_namespace n1 JOIN
pg_catalog.pg_class c1 ON (c1.relnamespace =
n1.oid) JOIN
pg_catalog.pg_index i ON (c1.oid =
i.indrelid) JOIN pg_catalog.pg_class
ic ON (i.indexrelid = ic.oid)
JOIN pg_catalog.pg_attribute a ON (ic.oid =
a.attrelid),
pg_catalog.pg_namespace n2 JOIN pg_catalog.pg_class c2 ON (c2.relnamespace =
n2.oid), pg_catalog.pg_trigger
t1 JOIN pg_catalog.pg_proc p1 ON (t1.tgfoid =
p1.oid), pg_catalog.pg_trigger
t2 JOIN pg_catalog.pg_proc p2 ON (t2.tgfoid = p2.oid) WHERE
(t1.tgrelid=c1.oid AND
t1.tgisconstraint AND
t1.tgconstrrelid=c2.oid AND p1.proname LIKE
'RI\\_FKey\\_%\\_upd') AND
(t2.tgrelid=c1.oid AND
t2.tgisconstraint AND
t2.tgconstrrelid=c2.oid AND p2.proname LIKE
'RI\\_FKey\\_%\\_del') AND i.indisprimary AND n2.nspname =
'public' ORDER BY FKTABLE_NAME , tgconstrname, keyseq; Would come back with values like: ref_a_c_l_right_sets_a_c_l\000a_c_l_right_sets\000a_c_l\000UNSPECIFIED\000a_c_l_id\000a_c_l_id\000 for t1.tgargs. but with postgresql-8.3.1, t1.args values are empty. Can someone please explain what changed
from 8.2.0 to 8.3.1 and how I need to update this query ? Thanks much, Suma |
