Michal Dobaczewski wrote:
> I wonder: how will postgres behave if it happens to generate a
> repetitive oid for a table with such constraint?
You get a constraint violation error.
> I understand it will
> work it out somehow internally and get a different oid,
No.
> but I would
> like to be sure. It doesn't create a risk of inserts failing at
> random, does it?
Yes, it would (for certain definitions of "random").
> I also understand this theoretically limits the number of rows in a
> table to 2^32 whereas without such constraint there is no set limit -
> is that true? It's not a problem, we don't have such big tables so
> far but it would be interesting to know.
If you're concerned about that, you better go back to sequences and use
bigserial columns.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
