Thread: How to find an oid that's not uesd now?

On 10/23/22 09:00, jacktby@gmail.com wrote:
> 
> I'm adding a new index in pg, but I find this.
> 
> Duplicate OIDs detected:
> 
> Duplicate OIDs detected:
> 
> 357
> 
> 357
> 
> found 1 duplicate OID(s) in catalog data
> 
> found 1 duplicate OID(s) in catalog data
> 
> what sql should I run to find one?

More information needed:

1) Postgres version?

2) What client reported that error?

3) What is the index creation statement you used?


-- 
Adrian Klaver
adrian.klaver@aklaver.com

"jacktby@gmail.com" <jacktby@gmail.com> writes:
> I'm adding a new index in pg, but I find this.

> Duplicate OIDs detected:
> Duplicate OIDs detected:
> 357
> 357
> found 1 duplicate OID(s) in catalog data
> found 1 duplicate OID(s) in catalog data
> what sql should I run to find one?

https://www.postgresql.org/docs/devel/system-catalog-initial-data.html#SYSTEM-CATALOG-OID-ASSIGNMENT

            regards, tom lane