The following bug has been logged on the website:
Bug reference: 14534
Logged by: Balazs Peter
Email address: balazs(at)obiserver(dot)hu
PostgreSQL version: 9.6.1
Operating system: Debian GNU/Linux 9
Description:
test=# create table test.testtable (id bigserial not null primary key, t
text not null);
CREATE TABLE
test=# alter table test.testtable rename to _testtable;
ERROR: type "_testtable" already exists
There is no, believe me!
test=# alter table test.testtable rename to testtable2;
ALTER TABLE
test=# alter table test.testtable2 rename to _testtable;
ALTER TABLE
Now it's possible? :)