pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPG 9.0.1 upgrade issues
6+ messages / 5 participants
[nested] [flat]
* PG 9.0.1 upgrade issues
@ 2010-10-15 19:18 Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2010-10-15 19:25 ` Re: PG 9.0.1 upgrade issues Devrim GÜNDÜZ <devrim@gunduz.org>
2010-10-15 19:30 ` Re: PG 9.0.1 upgrade issues Vibhor Kumar <vibhor.aim@gmail.com>
0 siblings, 2 replies; 6+ messages in thread
From: Isabella Ghiurea @ 2010-10-15 19:18 UTC (permalink / raw)
To: 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.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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PG 9.0.1 upgrade issues
2010-10-15 19:18 PG 9.0.1 upgrade issues Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
@ 2010-10-15 19:25 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2010-10-15 19:28 ` Re: PG 9.0.1 upgrade issues Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2010-10-15 19:31 ` Re: PG 9.0.1 upgrade issues Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 2 replies; 6+ messages in thread
From: Devrim GÜNDÜZ @ 2010-10-15 19:25 UTC (permalink / raw)
To: isabella.ghiurea@nrc-cnrc.gc.ca; +Cc: pgsql-admin
On Fri, 2010-10-15 at 12:18 -0700, Isabella Ghiurea wrote:
> 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
Could it be a non-9.0 aware client software?
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PG 9.0.1 upgrade issues
2010-10-15 19:18 PG 9.0.1 upgrade issues Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2010-10-15 19:25 ` Re: PG 9.0.1 upgrade issues Devrim GÜNDÜZ <devrim@gunduz.org>
@ 2010-10-15 19:28 ` Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
1 sibling, 0 replies; 6+ messages in thread
From: Isabella Ghiurea @ 2010-10-15 19:28 UTC (permalink / raw)
To: pgsql-admin; +Cc: Devrim GÜNDÜZ <devrim@gunduz.org>
Devrim GÜNDÜZ wrote:
> On Fri, 2010-10-15 at 12:18 -0700, Isabella Ghiurea wrote:
>
>> 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
>>
>
> Could it be a non-9.0 aware client software?
>
Yes , this maybe the case, I'm looking into more details know
Isabella
--
-----------------------------------------------------------
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PG 9.0.1 upgrade issues
2010-10-15 19:18 PG 9.0.1 upgrade issues Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2010-10-15 19:25 ` Re: PG 9.0.1 upgrade issues Devrim GÜNDÜZ <devrim@gunduz.org>
@ 2010-10-15 19:31 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-10-15 21:47 ` Re: PG 9.0.1 upgrade issues Guillaume Lelarge <guillaume@lelarge.info>
1 sibling, 1 reply; 6+ messages in thread
From: Tom Lane @ 2010-10-15 19:31 UTC (permalink / raw)
To: Devrim GÜNDÜZ <devrim@gunduz.org>; +Cc: isabella.ghiurea@nrc-cnrc.gc.ca; pgsql-admin
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim@gunduz.org> writes:
> On Fri, 2010-10-15 at 12:18 -0700, Isabella Ghiurea wrote:
>> ERROR: column t.tgisconstraint does not exist at character 387
> Could it be a non-9.0 aware client software?
So it would appear. pgAdmin maybe? I thought at first that it might be
an old version of pg_dump, but those queries don't quite match what an
8.4 pg_dump would issue.
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PG 9.0.1 upgrade issues
2010-10-15 19:18 PG 9.0.1 upgrade issues Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2010-10-15 19:25 ` Re: PG 9.0.1 upgrade issues Devrim GÜNDÜZ <devrim@gunduz.org>
2010-10-15 19:31 ` Re: PG 9.0.1 upgrade issues Tom Lane <tgl@sss.pgh.pa.us>
@ 2010-10-15 21:47 ` Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 6+ messages in thread
From: Guillaume Lelarge @ 2010-10-15 21:47 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Devrim GÜNDÜZ <devrim@gunduz.org>; isabella.ghiurea@nrc-cnrc.gc.ca; pgsql-admin
Le 15/10/2010 21:31, Tom Lane a écrit :
> Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim@gunduz.org> writes:
>> On Fri, 2010-10-15 at 12:18 -0700, Isabella Ghiurea wrote:
>>> ERROR: column t.tgisconstraint does not exist at character 387
>
>> Could it be a non-9.0 aware client software?
>
> So it would appear. pgAdmin maybe? I thought at first that it might be
> an old version of pg_dump, but those queries don't quite match what an
> 8.4 pg_dump would issue.
>
pgAdmin was my first guess. I checked on different releases (1.13, 1.12,
1.10) and none seems to have this kind of queries.
But I agree it should be a non-9.0 aware client software.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PG 9.0.1 upgrade issues
2010-10-15 19:18 PG 9.0.1 upgrade issues Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
@ 2010-10-15 19:30 ` Vibhor Kumar <vibhor.aim@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: Vibhor Kumar @ 2010-10-15 19:30 UTC (permalink / raw)
To: isabella.ghiurea@nrc-cnrc.gc.ca; +Cc: pgsql-admin
On Oct 16, 2010, at 12:48 AM, Isabella Ghiurea wrote:
> 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
Seems you are using connectors of PG8.4.4 with PG9.0
tgisconstraint column is no more part of pg_trigger table of PG9.0
Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftified.
Mob: +91-9011042623
Web:www.EnterpriseDB.com
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2010-10-15 21:47 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-10-15 19:18 PG 9.0.1 upgrade issues Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2010-10-15 19:25 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2010-10-15 19:28 ` Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2010-10-15 19:31 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-10-15 21:47 ` Guillaume Lelarge <guillaume@lelarge.info>
2010-10-15 19:30 ` Vibhor Kumar <vibhor.aim@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox