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...