OIDs wraparaound: postgresql (different versions) behavior

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux