OIDs wraparaound: postgresql (different versions) behavior

From: Francesco Dalla Ca' <f(dot)dallaca(at)cineca(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Subject: OIDs wraparaound: postgresql (different versions) behavior
Date: 2006-05-08 10:09:13
Message-ID: 445F18C5.1090709@cineca.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
--------------------------------------------------

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Francesco Dalla Ca' 2006-05-08 12:31:20 Meaning of contexts from pg_settings view
Previous Message Donald Fraser 2006-05-08 08:04:35 Constraint Triggers