Re: Does RENAME TABLE rename associated identity sequence?

On Thu, 24 Apr 2025 at 05:53, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
wrote:


> If there's any problem, IMO, ALTER TABLE ... RENAME ... should rename the
> sequence too since the identity sequences are created implicitly when the
> table is created, so they should be renamed implicitly. We should not
> require WITH SEQUENCE clause.
>

My concern would be what happens if the new sequence name is not available.
I suppose the simplest behaviour might be to skip renaming the sequence in
that case, perhaps raising a warning.