X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3AC269F9DD1 for ; Mon, 8 May 2006 07:29:43 -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 02733-06-2 for ; Mon, 8 May 2006 07:29:37 -0300 (ADT) X-Greylist: delayed 00:18:36.677867 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 293B49FA43B for ; Mon, 8 May 2006 07:29:31 -0300 (ADT) Received: from as2.cineca.com (as2.cineca.com [130.186.84.242]) by svr4.postgresql.org (Postfix) with ESMTP id A43705B5D99 for ; Mon, 8 May 2006 10:09:23 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by as2.cineca.com (Postfix) with ESMTP id 5CD5A3A9A0; Mon, 8 May 2006 12:09:19 +0200 (CEST) Received: from cineca.mm.cineca.it (cineca.mm.cineca.it [130.186.10.200]) by as2.cineca.com (Postfix) with ESMTP id D05E53A98F; Mon, 8 May 2006 12:09:13 +0200 (CEST) Received: from [130.186.7.26] (dhcp7-26.cineca.it [130.186.7.26]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) as user f.dallaca@cineca.it by cineca.mm.cineca.it (Postfix) with ESMTP id 8ADCB705A0D; Mon, 8 May 2006 12:09:13 +0200 (MEST) Message-ID: <445F18C5.1090709@cineca.it> From: Francesco Dalla Ca' Organization: CINECA User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20060202 Fedora/1.7.12-1.5.2 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: OIDs wraparaound: postgresql (different versions) behavior Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Date: Mon, 8 May 2006 12:09:13 +0200 (MEST) X-Virus-Scanned: Cineca AppOs 0.85 at as2.cineca.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/66 X-Sequence-Number: 21598 The PostgreSQL manual explain that from 8.1 the default behavior (governed by default_with_oids system parameter) is to create user tables "without oids". Well, at the page http://www.postgresql.org/docs/8.1/interactive/datatype-oid.html , the manual report this: "Object identifiers (OIDs) are used internally by PostgreSQL as primary keys for various system tables." What do i look and take care about the OID wraparound phenomenon? (On a DBA perspective) There is a possibility for a data inconsistency? (Or possibles database blocking errors?) What's the differents server behaviors for this phenomenon on differents realeases? Thank in advance for replies. Best regards, Francesco. -- -------------------------------------------------- Francesco Dalla Ca' Settore Gestione Sistemi CINECA Via Magnanelli 6/3 40033 Casalecchio di Reno (BO) Bologna, Italy http://www.cineca.it --------------------------------------------------