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