Search Postgresql Archives

Re: Upgrading from 8.2.0 to 8.3.1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 Bhat, Suma
Sent: Friday, April 04, 2008 3:07 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: [GENERAL] Upgrading from 8.2.0 to 8.3.1

 

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

 

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux