Re: 4 billion record limit?
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Paul Caskey <paul@nmxs.com>
Cc: Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>, Postgres Users <pgsql-general@postgresql.org>
Date: 2000-07-27T03:02:37Z
Lists: pgsql-general, pgsql-novice
Paul Caskey <paul@nmxs.com> writes: >> No doubt about it, you're likely to get a few "duplicate key" errors and >> stuff like that. I'm just observing that it's not likely to be a >> complete catastrophe, especially not if you don't rely on OIDs to be >> unique in your user tables. > I don't rely on OID uniqueness, but I assumed Postgres does! Only in the system tables, and not even in all of them. From the system's point of view, there's no real need to assign OIDs to user table rows at all --- so another possible answer is not to do that, unless the user requests it. regards, tom lane