Search system catalog for mystery type - Mailing list pgsql-general

From Carlo Stonebanks
Subject Search system catalog for mystery type
Date
Msg-id hcsa94$2f99$1@news.hub.org
Whole thread Raw
Responses Re: Search system catalog for mystery type  (Sam Mason <sam@samason.me.uk>)
Re: Search system catalog for mystery type  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
When I try the following command:
ALTER TABLE mdx_core.audit_impt RENAME TO _audit_impt;

I get the error message:

ERROR: type "_audit_impt" already exists
SQL state: 42710

I have looked through tables, types, sequences etc. I even did a PLAIN
schema (no data) backup on the DB and did a text search on the resulting
file for this name, nothing.

How do I search the system catalogs to find this particular "type"?



pgsql-general by date:

Previous
From: Joshua Tolley
Date:
Subject: Re: createlang error(s)
Next
From: Steve Crawford
Date:
Subject: Re: Postgres for mobile website?