Re: Re: [SQL] maximum number of rows in table - what about oid limits? - Mailing list pgsql-general

From Tom Lane
Subject Re: Re: [SQL] maximum number of rows in table - what about oid limits?
Date
Msg-id 9576.992011282@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re: [SQL] maximum number of rows in table - what about oid limits?  ("Tim Barnard" <tbarnard@povn.com>)
List pgsql-general
"Tim Barnard" <tbarnard@povn.com> writes:
> <snip>
> If it does happen, you can just retry the failed object-creation
> command until you get a nonconflicting OID assignment.
> <snip>

> Tom, or anyone who'd know for that matter, what is the
> exact error I would need to look for?

It'd be a complaint about attempt to insert a duplicate key into
the unique index on one of several system catalogs' OID columns.
There wouldn't be any earlier detection of the problem than that.

            regards, tom lane

pgsql-general by date:

Previous
From: jochen mader
Date:
Subject: too many clients
Next
From: Allan Kamau
Date:
Subject: Re: Writing transactions in plpgsql