Re: BUG #19455: ALTER TABLE RENAME will rename a sequence - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #19455: ALTER TABLE RENAME will rename a sequence
Date
Msg-id 823735.1776090122@sss.pgh.pa.us
Whole thread
In response to BUG #19455: ALTER TABLE RENAME will rename a sequence  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
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



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #19454: PL/pgSQL mishandling jsonb attribute reference
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #19455: ALTER TABLE RENAME will rename a sequence