Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id BD82F1337990 for ; Fri, 15 Oct 2010 18:47:52 -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 04278-03 for ; Fri, 15 Oct 2010 21:47:46 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-17937.dedibox.fr (sd-17937.dedibox.fr [88.191.100.74]) by mail.postgresql.org (Postfix) with ESMTP id 15EA81335B36 for ; Fri, 15 Oct 2010 18:47:44 -0300 (ADT) Received: from [192.168.1.7] (164.92.92-79.rev.gaoland.net [79.92.92.164]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id C70663B8F5; Fri, 15 Oct 2010 23:47:43 +0200 (CEST) Message-ID: <4CB8CBFF.4030304@lelarge.info> Date: Fri, 15 Oct 2010 23:47:43 +0200 From: Guillaume Lelarge User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); fr; rv:1.9.2.9) Gecko/20100915 Thunderbird/3.1.4 MIME-Version: 1.0 To: Tom Lane CC: =?ISO-8859-1?Q?Devrim_G=DCND=DCZ?= , isabella.ghiurea@nrc-cnrc.gc.ca, pgsql-admin@postgresql.org Subject: Re: PG 9.0.1 upgrade issues References: <4CB8A8F4.2050100@nrc-cnrc.gc.ca> <1287170701.2400.9.camel@hp-laptop02.gunduz.org> <10362.1287171105@sss.pgh.pa.us> In-Reply-To: <10362.1287171105@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201010/136 X-Sequence-Number: 35877 Le 15/10/2010 21:31, Tom Lane a écrit : > Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= 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