Posted by Erwin Moller on 10/01/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

• Next in forum: Re: evaluate expression inside array
• Prev in forum: Unable to create socket
• Thread view: Re: Why won't this code work in Postgresql and php?

[Reply to this message]