OIDs wraparaound: postgresql (different versions) behavior - Mailing list pgsql-admin

From Francesco Dalla Ca'
Subject OIDs wraparaound: postgresql (different versions) behavior
Date
Msg-id 445F18C5.1090709@cineca.it
Whole thread Raw
Responses Re: OIDs wraparaound: postgresql (different versions) behavior
List 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
--------------------------------------------------


pgsql-admin by date:

Previous
From: "Donald Fraser"
Date:
Subject: Constraint Triggers
Next
From: Francesco Dalla Ca'
Date:
Subject: Meaning of contexts from pg_settings view