Re: BUG #8176: problem with the "ALTER TYPE name RENAME TO new_name [ CASCADE | RESTRICT ]" syntax

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: BUG #8176: problem with the "ALTER TYPE name RENAME TO new_name [ CASCADE | RESTRICT ]" syntax
Дата
Msg-id 20130527142352.GT8597@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: BUG #8176: problem with the "ALTER TYPE name RENAME TO new_name [ CASCADE | RESTRICT ]" syntax  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-bugs
Maxim,

* Stephen Frost (sfrost@snowman.net) wrote:
> * maxim.boguk@gmail.com (maxim.boguk@gmail.com) wrote:
> > It seems that documentation wrong or [ CASCADE | RESTRICT ] feature of =
ALTER
> > TYPE ... RENAME TO isn't implemented.
>=20
> Actually, I'm pretty sure it's implemented but the grammar for it was
> broken during refactoring to have all the ALTER .. RENAME operations go
> through the same code paths.

Nope, I was wrong- this looks to be a documentation bug, actually.  The
documentation should be:

ALTER TYPE name RENAME ATTRIBUTE attribute_name TO new_attribute_name [ CAS=
CADE | RESTRICT ]
ALTER TYPE name RENAME TO new_name

Which makes more sense (to me at least) anyway.  Do you have a need for
this version:

ALTER TYPE name RENAME TO new_name [ CASCADE | RESTRICT ]

or were you just playing with things..?

    Thanks,

        Stephen

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #8176: problem with the "ALTER TYPE name RENAME TO new_name [ CASCADE | RESTRICT ]" syntax
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: BUG #8176: problem with the "ALTER TYPE name RENAME TO new_name [ CASCADE | RESTRICT ]" syntax