Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 41ED72E301C for ; Wed, 12 Dec 2007 00:20:31 -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 01544-06 for ; Wed, 12 Dec 2007 00:20:25 -0400 (AST) Received: from smtp4.clear.net.nz (smtp4.clear.net.nz [203.97.37.64]) by postgresql.org (Postfix) with ESMTP id 75AEA2E2F45 for ; Wed, 12 Dec 2007 00:20:25 -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 <0JSX00CD15DZ0M00@smtp4.clear.net.nz> for pgsql-admin@postgresql.org; Wed, 12 Dec 2007 17:20:24 +1300 (NZDT) Received: from localhost (localhost [127.0.0.1]) by mail.spmconsultants.co.nz (Postfix) with ESMTP id 6B9664255 for ; Wed, 12 Dec 2007 17:20:20 +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 83298-04 for ; Wed, 12 Dec 2007 17:20:14 +1300 (NZDT) Received: from [10.8.0.14] (unknown [10.8.0.14]) by mail.spmconsultants.co.nz (Postfix) with ESMTP id 1D4824216 for ; Wed, 12 Dec 2007 17:20:11 +1300 (NZDT) Date: Wed, 12 Dec 2007 17:20:42 +1300 From: Wouter Pels Subject: sequence owned by backwards compatability To: pgsql-admin@postgresql.org Reply-to: wouter@spmapplications.com Message-id: <475F619A.4060300@spmapplications.com> Organization: SPM Consultants MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en-us, en X-Virus-Scanned: amavisd-new at spmconsultants.co.nz 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-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200712/61 X-Sequence-Number: 27578 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 ? have thought of parsing the dump through a convert script to translate the SET OWNED to an ALTER COLUMN, but if there may be an easier way to achieve the same result. thanks in advance, regards wouter