X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7CDA39FA621; Fri, 9 Jun 2006 10:46:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 40065-04; Fri, 9 Jun 2006 10:46:16 -0300 (ADT) X-Greylist: delayed 00:20:17.054521 by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.aeccom.com (port-83-236-156-26.static.qsc.de [83.236.156.26]) by postgresql.org (Postfix) with ESMTP id 95D989FA61D; Fri, 9 Jun 2006 10:46:16 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.aeccom.com (Postfix) with ESMTP id C79481CA59; Fri, 9 Jun 2006 15:25:56 +0200 (CEST) Received: from mail.aeccom.com ([127.0.0.1]) by localhost (gate6.aeccom.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 08483-01-30; Fri, 9 Jun 2006 15:25:55 +0200 (CEST) Received: from [192.168.2.12] (cayambe.core.aeccom.com [192.168.2.12]) by mail.aeccom.com (Postfix) with ESMTP id E9B841CA39; Fri, 9 Jun 2006 15:25:55 +0200 (CEST) Message-ID: <448976E3.50209@aeccom.com> Date: Fri, 09 Jun 2006 15:25:55 +0200 From: =?UTF-8?B?RGlyayBMdXR6ZWLDpGNr?= Organization: AEC/communications GmbH User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: pgsql-admin@postgresql.org, pgsql-general@postgresql.org, pgsql-bugs@postgresql.org CC: tgl@sss.pgh.pa.us Subject: How to set the global OID counter? COPY WITH OIDS does not set global OID counter? Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at aeccom.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/68 X-Sequence-Number: 22030 Hi, how can one set the global OID counter in 8.1.X? We think it would work in 8.0.X using the COPY WITH OIDS command but this does not work in 8.1.X anymore. We have the problem that we made a dump using 'pg_dump -o' in 8.0.X, created a new database in 8.1.X and read back in but the global OID counter stayed at 40.000 so OIDs will be allocated again! Thanks for help, Dirk