RE: OID wrap around

From: <jeff(dot)fitzmyers(at)managestar(dot)com>
To: <thalis(at)cs(dot)pitt(dot)edu>, <pgsql-general(at)postgresql(dot)org>
Subject: RE: OID wrap around
Date: 2001-05-24 22:51:10
Message-ID: 371EAC487A83CD4296F6999FD088D83305B725@atlas.managestar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Remembering past discussions: Yes OID's wrap around. When this happens,
they will not nesecarily be unique anymore. Apparently this should not
be a problem unless one has queries that specifically use OID's. INT8
OID's have been talked about and will probably be implemented some day.

Jeff
>>>>>
Someone mentioned the OIDs are unique for every row for an entire
database cluster. I also notice that they are not being reused (like a
sequence). Will they wrap around as soon as the 2^32 boundary is hit?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ludwig Meyerhoff 2001-05-25 00:03:09 Pg - Perl 5 prob
Previous Message Vince Vielhaber 2001-05-24 22:00:43 RE: ERWin