index problem when renaming a table

Поиск
Список
Период
Сортировка
От lists
Тема index problem when renaming a table
Дата
Msg-id 009d01c2fab1$90d48f40$80faabc8@insyde
обсуждение исходный текст
Список pgsql-bugs
Hi ,

I used the command:

ALTER TABLE TEST_TABLE RENAME TO TEST_TABLE_01;

and tried to create a new one, based on the old, with some more fields.
But when I create the primary key, it says that it's name is already used
and it can't be dome, and exits.

Then I have to drop the old table's index, recreate it and create the new
table again. Isn't it a bug? Why can't I have the same name in 2 or more
tables in the same database? Or why PostgreSQL don't create a PK with
some random name (say PK_TBL01_1234) to each table so the index
name won't be duplicated?

TIA,
Ricardo.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Robert John Shepherd"
Дата:
Сообщение: Rapid deteriation of performance (might be caused by tsearch?) in 7.3.2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Rapid deteriation of performance (might be caused by tsearch?) in 7.3.2