Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 358DA1337BDB for ; Fri, 15 Oct 2010 16:23:45 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 20311-10 for ; Fri, 15 Oct 2010 19:23:37 +0000 (UTC) X-Greylist: delayed 00:05:18.450145 by SQLgrey-1.7.6 Received: from nrccenhts1.nrc.ca (nrccenhts1.nrc.ca [132.246.15.88]) by mail.postgresql.org (Postfix) with ESMTP id D7E9B1337BD5 for ; Fri, 15 Oct 2010 16:23:35 -0300 (ADT) Received: from NRCWSTHCM1.NRC.CA (132.246.216.66) by nrccenhts1.nrc.ca (132.246.15.88) with Microsoft SMTP Server (TLS) id 8.1.436.0; Fri, 15 Oct 2010 15:18:15 -0400 Received: from [132.246.194.17] (132.246.216.202) by WSTMAIL.NRC.CA (132.246.216.66) with Microsoft SMTP Server (TLS) id 8.1.436.0; Fri, 15 Oct 2010 12:18:14 -0700 Message-ID: <4CB8A8F4.2050100@nrc-cnrc.gc.ca> Date: Fri, 15 Oct 2010 12:18:12 -0700 From: Isabella Ghiurea Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca Organization: CADC -NRC User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: Subject: PG 9.0.1 upgrade issues Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_40=-0.001 X-Spam-Level: X-Archive-Number: 201010/130 X-Sequence-Number: 35871 Hi All, I have upgrade my existing env PG 8.4.4 to PG 9.0.1 , run a dump and restore and recreate the table space. The upgrade went smooth no issues until I restart the db and I see this in PG erorrlog, any ideas if this is a new table or any changes have been made to this table. ERROR: column t.tgisconstraint does not exist at character 387 2010-10-15 12:09:56 PDT[25262]:[2-1]STATEMENT: SELECT t.oid, t.tgname AS name, t.tgtype, t.tgenabled, t.tgdeferrable, t.tginitdeferred, t.tgnargs, t.tgargs, p.proname, ds.description, pn.nspname AS procnsp FROM pg_trigger t LEFT OUTER JOIN pg_proc p ON t.tgfoid = p.oid INNER JOIN pg_class c ON t.tgrelid = c.oid LEFT OUTER JOIN pg_description ds ON ds.objoid = t.oid LEFT OUTER JOIN pg_namespace pn ON pn.oid = p.pronamespace WHERE t.tgisconstraint = 'f' AND c.oid = 16444 ORDER BY t.tgname 2010-10-15 12:09:56 PDT[25263]:[1-1]ERROR: column t.tgisconstraint does not exist at character 387 2010-10-15 12:09:56 PDT[25263]:[2-1]STATEMENT: SELECT t.oid, t.tgname AS name, t.tgtype, t.tgenabled, t.tgdeferrable, t.tginitdeferred, t.tgnargs, t.tgargs, p.proname, ds.description, pn.nspname AS procnsp FROM pg_trigger t LEFT OUTER JOIN pg_proc p ON t.tgfoid = p.oid INNER JOIN pg_class c ON t.tgrelid = c.oid LEFT OUTER JOIN pg_description ds ON ds.objoid = t.oid LEFT OUTER JOIN pg_namespace pn ON pn.oid = p.pronamespace WHERE t.tgisconstraint = 'f' AND c.oid = 16453 ORDER BY t.tgname 2010-10-15 12:09:56 PDT[25264]:[1-1]ERROR: column t.tgisconstraint does not exist at character 387 2010-10-15 12:09:56 PDT[25264]:[2-1]STATEMENT: SELECT t.oid, t.tgname AS name, t.tgtype, t.tgenabled, t.tgdeferrable, t.tginitdeferred, t.tgnargs, t.tgargs, p.proname, ds.description, pn.nspname AS procnsp FROM pg_trigger t LEFT OUTER JOIN pg_proc p ON t.tgfoid = p.oid INNER JOIN pg_class c ON t.tgrelid = c.oid LEFT OUTER JOIN pg_description ds ON ds.objoid = t.oid LEFT OUTER JOIN pg_namespace pn ON pn.oid = p.pronamespace WHERE t.tgisconstraint = 'f' AND c.oid = 16506 ORDER BY t.tgname 2010-10-15 12:10:03 PDT[25267]:[1-1]ERROR: column t.tgisconstraint does not exist at character 471 2010-10-15 12:10:03 PDT[25267]:[2-1]STATEMENT: SELECT t.oid, t.tgname AS name, t.tgtype, t.tgenabled, t.tgdeferrable, t.tginitdeferred, t.tgnargs, t.tgargs, p.proname, ds.description, pn.nspname AS procnsp, n.nspname AS relnsp, c.relname FROM pg_trigger t LEFT OUTER JOIN pg_proc p ON t.tgfoid = p.oid INNER JOIN pg_class c ON t.tgrelid = c.oid LEFT OUTER JOIN pg_description ds ON ds.objoid = t.oid LEFT OUTER JOIN pg_namespace pn ON pn.oid = p.pronamespace INNER JOIN pg_namespace n ON c.relnamespace = n.oid WHERE t.tgisconstraint = 'f' ORDER BY c.relname, n.nspname, t.tgname 2010-10-15 12:10:04 PDT[25268]:[1-1]ERROR: column t.tgisconstraint does not exist at character 209 2010-10-15 12:10:04 PDT[25268]:[2-1]STATEMENT: SELECT t.oid, t.tgname AS name, t.tgtype, t.tgenabled, c.relname AS tablename, n.nspname FROM pg_trigger t INNER JOIN pg_class c ON t.tgrelid = c.oid INNER JOIN pg_namespace n ON c.relnamespace = n.oid WHERE t.tgisconstraint = 'f' ORDER BY t.tgname, c.relname 2010-10-15 12:10:09 PDT[25269]:[1-1]ERROR: column t.tgisconstraint does not exist at character 209 2010-10-15 12:10:09 PDT[25269]:[2-1]STATEMENT: SELECT t.oid, t.tgname AS name, t.tgtype, t.tgenabled, c.relname AS tablename, n.nspname FROM pg_trigger t INNER JOIN pg_class c ON t.tgrelid = c.oid INNER JOIN pg_namespace n ON c.relnamespace = n.oid WHERE t.tgisconstraint = 'f' ORDER BY t.tgname, c.relname 2010-10-15 12:10:11 PDT[25270]:[1-1]ERROR: column t.tgisconstraint does not exist at character 387 2010-10-15 12:10:11 PDT[25270]:[2-1]STATEMENT: SELECT t.oid, t.tgname AS name, t.tgtype, t.tgenabled, t.tgdeferrable, t.tginitdeferred, t.tgnargs, t.tgargs, p.proname, ds.description, pn.nspname AS procnsp FROM pg_trigger t LEFT OUTER JOIN pg_proc p ON t.tgfoid = p.oid INNER JOIN pg_class c ON t.tgrelid = c.oid LEFT OUTER JOIN pg_description ds ON ds.objoid = t.oid LEFT OUTER JOIN pg_namespace pn ON pn.oid = p.pronamespace WHERE t.tgisconstraint = 'f' AND c.oid = 16444 ORDER BY t.tgname 2010-10-15 12:10:11 PDT[25271]:[1-1]ERROR: column t.tgisconstraint does not exist at character 387 2010-10-15 12:10:11 PDT[25271]:[2-1]STATEMENT: SELECT t.oid, t.tgname AS name, t.tgtype, t.tgenabled, t.tgdeferrable, t.tginitdeferred, t.tgnargs, t.tgargs, p.proname, ds.description, pn.nspname AS procnsp FROM pg_trigger t LEFT OUTER JOIN pg_proc p ON t.tgfoid = p.oid INNER JOIN pg_class c ON t.tgrelid = c.oid LEFT OUTER JOIN pg_description ds ON ds.objoid = t.oid LEFT OUTER JOIN pg_namespace pn ON pn.oid = p.pronamespace WHERE t.tgisconstraint = 'f' AND c.oid = 16453 ORDER BY t.tgname 2010-10-15 12:10:11 PDT[25272]:[1-1]ERROR: column t.tgisconstraint does not exist at character 387 2010-10-15 12:10:11 PDT[25272]:[2-1]STATEMENT: SELECT t.oid, t.tgname AS name, t.tgtype, t.tgenabled, t.tgdeferrable, t.tginitdeferred, t.tgnargs, t.tgargs, p.proname, ds.description, pn.nspname AS procnsp FROM pg_trigger t LEFT OUTER JOIN pg_proc p ON t.tgfoid = p.oid INNER JOIN pg_class c ON t.tgrelid = c.oid LEFT OUTER JOIN pg_description ds ON ds.objoid = t.oid LEFT OUTER JOIN pg_namespace pn ON pn.oid = p.pronamespace WHERE t.tgisconstraint = 'f' AND c.oid = 16506 ORDER BY t.tgname -- ----------------------------------------------------------- Isabella A. Ghiurea Isabella.Ghiurea@nrc-cnrc.gc.ca Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National Research Council of Canada, Herzberg Institute of Astrophysics 5071 West Saanich Road, Victoria BC V9E 2E7, Canada Phone: 250 363-3446 fax: 250 363-0045