Carlo Stonebanks wrote: > 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
Probably the easiest way around this is to use two underscores instead of one: ALTER TABLE mdx_core.audit_impt RENAME TO __audit_impt; Or any other char for that matter -- you picked the only one that would cause a problem. Even a space should be fine: ALTER TABLE mdx_core.audit_impt RENAME TO " audit_impt"; (Not sure I can recommend this though) -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
