Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 8709B2E031E for ; Wed, 12 Dec 2007 04:31:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 23404-08 for ; Wed, 12 Dec 2007 04:31:26 -0400 (AST) Received: from smtp4.clear.net.nz (smtp4.clear.net.nz [203.97.37.64]) by postgresql.org (Postfix) with ESMTP id E7BAF2E02A1 for ; Wed, 12 Dec 2007 04:31:28 -0400 (AST) Received: from mail.spmconsultants.co.nz (203-97-48-235.dsl.clear.net.nz [203.97.48.235]) by smtp4.clear.net.nz (CLEAR Net Mail) with ESMTP id <0JSX00F70H0E1Z40@smtp4.clear.net.nz> for pgsql-admin@postgresql.org; Wed, 12 Dec 2007 21:31:27 +1300 (NZDT) Received: from localhost (localhost [127.0.0.1]) by mail.spmconsultants.co.nz (Postfix) with ESMTP id 7F6774202 for ; Wed, 12 Dec 2007 21:31:22 +1300 (NZDT) Received: from mail.spmconsultants.co.nz ([127.0.0.1]) by localhost (einstein.spmconsultants.co.nz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 84554-04 for ; Wed, 12 Dec 2007 21:31:18 +1300 (NZDT) Received: from [10.8.0.14] (unknown [10.8.0.14]) by mail.spmconsultants.co.nz (Postfix) with ESMTP id E991D41A9 for ; Wed, 12 Dec 2007 21:31:14 +1300 (NZDT) Date: Wed, 12 Dec 2007 21:31:46 +1300 From: Wouter Pels Subject: Re: sequence owned by backwards compatability In-reply-to: <475F6C5B.2060405@commandprompt.com> To: pgsql-admin@postgresql.org Reply-to: wouter@spmapplications.com Message-id: <475F9C72.8000403@spmapplications.com> Organization: SPM Consultants MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: 7bit X-Accept-Language: en-us, en X-Virus-Scanned: amavisd-new at spmconsultants.co.nz References: <475F619A.4060300@spmapplications.com> <475F6C5B.2060405@commandprompt.com> User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20060324 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/64 X-Sequence-Number: 27581 Joshua D. Drake wrote: > 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. > Don't like the idea of manualy editing the schema, seems like a waste of time, specialy knowing that the situation will pop up more then once I guess a data only restore will work on existing 8.1.x databases, but then there is the hassle of truncating tables and disabling/enabling triggers and all the the other yet unknown trouble. > Out of curiosity.. why are you doing this? :) We are working with multiple configurations from 8.0.x to 8.2.x, its imposible to upgrade them all at the same time. Dump and restore of the complete database ..was.. allways the easiest way to get all data across.