Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E6CF12E371E for ; Wed, 12 Dec 2007 01:12:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 49240-04-4 for ; Wed, 12 Dec 2007 01:12:49 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id BF3A12E3689 for ; Wed, 12 Dec 2007 01:06:30 -0400 (AST) Received: from [192.168.1.226] (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id lBC56RQn000538 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 11 Dec 2007 21:06:29 -0800 Message-ID: <475F6C5B.2060405@commandprompt.com> Date: Tue, 11 Dec 2007 21:06:35 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 1.5.0.13 (Windows/20070809) MIME-Version: 1.0 To: wouter@spmapplications.com CC: pgsql-admin@postgresql.org Subject: Re: sequence owned by backwards compatability References: <475F619A.4060300@spmapplications.com> In-Reply-To: <475F619A.4060300@spmapplications.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 11 Dec 2007 21:06:29 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/62 X-Sequence-Number: 27579 Wouter Pels wrote: > We were running into problems today when we tried to import a 8.2.4 dump > in a 8.1.5 database. It had to do with the new way of assigning > sequences to colums, which confused 8.1.5 I didn't expect that at the > time of configuration, and currently is down-grading to 8.1.x not an > easy option anymore. > > Is there any trick to work arround this issue ? some kind of switch for > backwards compatability ? No switch but you could restore the schema separately from the data. Then you could edit the schema to fit 8.1 commands before restore. Out of curiosity.. why are you doing this? :) Joshua D. Drake