Posted by Erwin Moller on 12/17/92 11:55

Tim Roberts wrote:

> "rich" <rhdyes@gmail.com> wrote:
>>
>>I have done some reading and I can't remember where that states if you
>>don't need to use OID's don't. There is a finite number of them within
>>the database and you can hit that limit. I know its a huge number, but
>>why use them?
>
> 4 billion. It takes one hell of a lot of INSERTs to get to 4 billion.
>
>>I usually have my primary keys on each of the tables I design. Isn't
>>that redundant?
>
> Usually.
>
> (That's a little joke. If you "usually have primary keys", then OIDs will
> usually be redundant.)

LOL, indeed. :-)
To OP: I was also joking when I asked what your problem was with OIDs.
You don't need them if you design your databases good (=all tables have
PK/serials and all references are enforced via Foreign Keys).

Regards,
Erwin Moller

[Back to original message]