Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 236081337BA3 for ; Fri, 15 Oct 2010 16:29:48 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 70902-02 for ; Fri, 15 Oct 2010 19:29:41 +0000 (UTC) X-Greylist: from auto-whitelisted 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 BA8191337B84 for ; Fri, 15 Oct 2010 16:29:40 -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:29:40 -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:28:54 -0700 Message-ID: <4CB8AB75.3080004@nrc-cnrc.gc.ca> Date: Fri, 15 Oct 2010 12:28:53 -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: "pgsql-admin@postgresql.org" CC: =?ISO-8859-1?Q?Devrim_G=DCND=DCZ?= Subject: Re: PG 9.0.1 upgrade issues References: <4CB8A8F4.2050100@nrc-cnrc.gc.ca> <1287170701.2400.9.camel@hp-laptop02.gunduz.org> In-Reply-To: <1287170701.2400.9.camel@hp-laptop02.gunduz.org> Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_20=-0.001 X-Spam-Level: X-Archive-Number: 201010/132 X-Sequence-Number: 35873 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