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