BUG #10316: Alter table rename fails if the "new name" starts with '_'
От | parthibanp2@gmail.com |
---|---|
Тема | BUG #10316: Alter table rename fails if the "new name" starts with '_' |
Дата | |
Msg-id | 20140514124119.11846.62730@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #10316: Alter table rename fails if the "new name" starts with '_'
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 10316 Logged by: Parthi Email address: parthibanp2@gmail.com PostgreSQL version: 9.3.2 Operating system: Mac OSX 10.9.2 Description: Hi I'm facing one peculiar behaviour(bug?) with Alter table rename query SQL. -- I have created one new table with name t1 test=# \d No relations found. test=# create table t1 (name varchar(10)); CREATE TABLE -- After that i tried to rename 't1' table as '_t1', now the Postgres server saying '_t1' is already exists. i'm sure there is no other table in the database other than 't1'. test=# alter table t1 rename to _t1; ERROR: type "_t1" already exists -- Now i renaming table from 't1' to '__t1' and again i renaming from '__t1' to '_t1' now its working. test=# alter table t1 rename to __t1; ALTER TABLE test=# alter table __t1 rename to _t1; ALTER TABLE -- Again i renamed '_t1' to 't1', once again i tried the first query , now its working. test=# alter table _t1 rename to t1; ALTER TABLE test=# alter table t1 rename to _t1; ALTER TABLE May i know , why the rename query failed initially? if it is bug then how the same query succeeded during second time?
В списке pgsql-bugs по дате отправления: