Re: [GENERAL] Question about pg_catalog.pg_trigger.

2008-04-04 Thread Tom Lane
"Bhat, Suma" <[EMAIL PROTECTED]> writes: > but with postgresql-8.3.1, t1.args values are empty. Yes, the RI triggers no longer care about tgargs. They look at the FK constraint's pg_constraint entry, instead. regards, tom lane -- Sent via pgsql-general mailing list (pgs

[GENERAL] Question about pg_catalog.pg_trigger.

2008-04-04 Thread Bhat, Suma
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, t