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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
