Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field
Дата
Msg-id 27122.1191432838@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field  (Heikki Linnakangas <heikki@enterprisedb.com>)
Ответы Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-bugs
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> Well, the way it is now is just broken, so IMO we have to either fix it
> or remove it altogether.

> Since having sequence_name in there doesn't let you do anything you
> can't do without it, and there's no easy way to fix it, I'd say let's
> just remove it in 8.3 and do nothing in backbranches.

I don't think this is a good idea.  It's removing functionality that
works fine as long as you don't rename sequences.  Also, there's still
the notion of someday providing a system catalog or view that shows
parameters of all sequences, and in that view the current column set of
an individual sequence would be what we'd want.

My inclination is to leave it alone for now until we have an approach to
providing that view, and at that time decide what to do about individual
sequences.  If we have to change the API, then so be it, but lets do it
just once not twice.

            regards, tom lane

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field
Следующее
От: "Anton A. Patrushev"
Дата:
Сообщение: Re: BUG #3648: Server crashes when trying to create a table