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