Skip site navigation (1) Skip section navigation (2)

PG 9.0.1 upgrade issues

From: Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: PG 9.0.1 upgrade issues
Date: 2010-10-15 19:18:12
Message-ID: 4CB8A8F4.2050100@nrc-cnrc.gc.ca (view raw or flat)
Thread:
Lists: pgsql-admin
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(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)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


Responses

pgsql-admin by date

Next:From: Tony CapobiancoDate: 2010-10-15 19:22:52
Subject: Re: oracle to psql migration - slow query in postgres
Previous:From: Igor NeymanDate: 2010-10-15 18:54:11
Subject: Re: oracle to psql migration - slow query in postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group