Postgres Pro
Downloads
Home   >   mailing lists

Re: How to find an oid that's not uesd now? - Mailing list pgsql-general

From Tom Lane
Subject Re: How to find an oid that's not uesd now?
Date
Msg-id 3549952.1666544293@sss.pgh.pa.us
Whole thread Raw
In response to How to find an oid that's not uesd now?  ("jacktby@gmail.com" <jacktby@gmail.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: Asking for existence of a GUI frame work similar to Oracle APEX for PostgreSQL
Next
From: chris navarroza
Date:
Subject: Re: Upgrading error