| 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: | Whole Thread | Raw Message | 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 |