X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8633C3A481E for ; Thu, 28 Oct 2004 07:22:11 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53907-09 for ; Thu, 28 Oct 2004 06:22:09 +0000 (GMT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 3D99D3A4803 for ; Thu, 28 Oct 2004 07:22:09 +0100 (BST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id B7A5C35995; Wed, 27 Oct 2004 23:22:06 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id B63D535919; Wed, 27 Oct 2004 23:22:06 -0700 (PDT) Date: Wed, 27 Oct 2004 23:22:06 -0700 (PDT) From: Stephan Szabo To: Andrei Bintintan Cc: pgsql-admin@postgresql.org Subject: Re: pg_dump doesn't save correct the sequences In-Reply-To: <025201c4bcb1$fb556f10$0b00a8c0@forge> Message-ID: <20041027231815.Q66903@megazone.bigpanda.com> References: <025201c4bcb1$fb556f10$0b00a8c0@forge> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/359 X-Sequence-Number: 15352 On Thu, 28 Oct 2004, Andrei Bintintan wrote: > I try to dump a database from a 7.4.2 postgre system and to import it on > a 7.3.2. system, but I have a problem with the sequences in the dump. In general, the above is not guaranteed to work. pg_dump will use features of the dumping version so moving the dump to an earlier version is filled with danger. > This is a seq example: > > CREATE SEQUENCE test_id_seq > INCREMENT BY 1 > NO MAXVALUE > NO MINVALUE > CACHE 1; > > This gives me an error when restoring on the 7.3 machine. Looking at the documentation, it looks like NO MAXVALUE and NO MINVALUE were added in 7.4. > I don't know what happened, because last week I also put a dump from 7.4 > to 7.3 without any problems. > A coelege from me made an application and some modifications in the 7.4 > database system, now I see that in every database there are these tables > that weren't before: sql_features, sql_implementation_info, > sql_languages, sql_packages, sql_sizing, sql_sizing_profiles. I believe these are part of the SQL standard information_schema.