Re: Does RENAME TABLE rename associated identity sequence?

Поиск
Список
Период
Сортировка
От Isaac Morland
Тема Re: Does RENAME TABLE rename associated identity sequence?
Дата
Msg-id CAMsGm5e4gT3HNaRZDRbdzC3gg=kp6YKQVq48prMwEUAfh9zOFg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Does RENAME TABLE rename associated identity sequence?  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
Ответы Re: Does RENAME TABLE rename associated identity sequence?
Список pgsql-hackers
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. 
 

В списке pgsql-hackers по дате отправления: