Re: ALTER SEQUENCE

Bruce Momjian wrote:
> Don Y wrote:
>> Hi,
>>
>> It doesn't appear that there is a way to rename a sequence
>> (ideally with a "cascade" action).
>
>
> Uh, the ALTER SEQUENCE manual page says:

Uh, the 8.0.3 man page for ALTER SEQUENCE makes no mention of this.
Nor does "\h ALTER SEQUENCE" in psql yield any pointers.

>        Some variants of ALTER TABLE can be used with sequences as
>        well; for example, to rename a sequence  use  ALTER  TABLE
>        RENAME.
>
> Does that help?

Sure!  It appears to allow both the rename and change of ownership.
Thanks!

Obviously, the documentation doesn't agree with the code  :-(

But, it still leaves unanswered the question of the risk involved
in just changing the name/owner in the system tables...