On Wed, Nov 04, 2009 at 11:31:55AM -0500, Carlo Stonebanks wrote:
> When I try the following command:
> ALTER TABLE mdx_core.audit_impt RENAME TO _audit_impt;
>
> ERROR: type "_audit_impt" already exists
>
> How do I search the system catalogs to find this particular "type"?
select typname, typinput, typoutput from pg_type;
may help. I've not realized before, but most types/relations seem to
appear again with an underscore (i.e. your case) for their array type.
See:
http://www.postgresql.org/docs/current/static/sql-createtype.html#SQL-CREATETYPE-NOTES
--
Sam http://samason.me.uk/