X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2E33E11F6746 for ; Mon, 17 Apr 2006 15:23:09 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.293 X-Spam-Level: X-Spam-Status: No, score=0.293 required=5 tests=[AWL=0.293] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id HaydZ5TdIo7M for ; Mon, 17 Apr 2006 15:23:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from pproxy.gmail.com (pproxy.gmail.com [64.233.166.180]) by postgresql.org (Postfix) with ESMTP id E61C111F6763 for ; Mon, 17 Apr 2006 15:23:01 -0300 (ADT) Received: by pproxy.gmail.com with SMTP id x66so634777pye for ; Mon, 17 Apr 2006 11:23:00 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=cv1/mqHaSB5TOhbGiKk1kwqLz+QTh/hK5IXNAVCDrHSMbV48lbcmV7N4qWMloTubz2+flm630yE0IS99sxt08MrPZ8LC+rRIDCYjMr0QQ1Z5oEMpau7bxf+uZXtSQnT2U00sa8YAe78yE9f3tSqwIadl6MvdwAvhloAPQrKju1U= Received: by 10.35.22.17 with SMTP id z17mr686657pyi; Mon, 17 Apr 2006 11:23:00 -0700 (PDT) Received: by 10.35.103.9 with HTTP; Mon, 17 Apr 2006 11:23:00 -0700 (PDT) Message-ID: Date: Mon, 17 Apr 2006 19:23:00 +0100 From: "Guido Barosio" To: tony Subject: Re: downward dump compatibility Cc: pgsql-admin@postgresql.org In-Reply-To: <1145277505.7534.16.camel@hush.localdomain> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1145277505.7534.16.camel@hush.localdomain> X-Archive-Number: 200604/147 X-Sequence-Number: 21316 Dunno, but it sounds like a "no" at a first sight. What about dumping with INSERTS instead of COPY ? That should work tho. g.- On 4/17/06, tony wrote: > Hello, > > Is it possible to import a 8.1.1 dump file (standard format) into a > 7.3.9 database? > > I have an intranet with the most recent version and a public serveur > with selected data which is still running 7.3. > > I am seeing an error with "\N" > > Cheers > > Tony > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- Guido Barosio ----------------------- http://www.globant.com guido.barosio@globant.com