Home > mailing lists

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

From	jacktby@gmail.com
Subject	How to find an oid that's not uesd now?
Date	October 23, 2022 19:00:56
Msg-id	202210240000544499483@gmail.com Whole thread Raw
Responses	Re: How to find an oid that's not uesd now? Re: How to find an oid that's not uesd now?
List	pgsql-general

I'm adding a new index in pg, but I find this.

Duplicate OIDs detected:

Duplicate OIDs detected:

found 1 duplicate OID(s) in catalog data

found 1 duplicate OID(s) in catalog data

what sql should I run to find one?

From: Tom Lane
Date: 23 October 2022, 07:36:32
Subject: Re: pg_restore 12 "permission denied for schema" errors

From: Adrian Klaver
Date: 23 October 2022, 19:06:34
Subject: Re: How to find an oid that's not uesd now?