PG Bug reporting form <noreply@postgresql.org> writes:
> Is this expected behavior? ALTER TABLE RENAME will rename a sequence.
Yes, it is. It'll work on views and (most?) other kinds of relations
too.
To some extent this is a hangover from before we had the more
specialized variants. But it can be handy to not worry too much
about just what kind of relation you're renaming, and tightening
that up would likely break some applications, so we haven't.
regards, tom lane