Re: Unable to determine what has a particular OID

Greg Smith <greg@2ndquadrant.com> writes:
> Andy Dale wrote:
>> I will however save/backup the files before removing them (just in
>> case anything goes wrong).

> If you do go through with this, I would recommend doing a complete
> database dump afterwards using pg_dump/pg_dumpall.  That should make it
> immediately obvious if you broke something with the change.

Doing pg_dump would expose the mistake if you'd removed an actual
table's files.  But I'm not sure it would expose it if you removed
an index ...

            regards, tom lane