BUG #14534: renaming table error
The following bug has been logged on the website:
Bug reference: 14534
Logged by: Balazs Peter
Email address: balazs@obiserver.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? :)
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
balazs@obiserver.hu writes:
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!
Yes, there is ... it's the name given to the array type over the
table's composite type.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs