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

Maxim,

* Stephen Frost (sfrost(at)snowman(dot)net) wrote:
> * maxim(dot)boguk(at)gmail(dot)com (maxim(dot)boguk(at)gmail(dot)com) wrote:
> > It seems that documentation wrong or [ CASCADE | RESTRICT ] feature of ALTER
> > TYPE ... RENAME TO isn't implemented.
>
> 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 [ CASCADE | 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