Re: BUG #17252: Alter Column Length with dependent Views

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17252: Alter Column Length with dependent Views
Дата
Msg-id CAKFQuwZk5oF_B1d2tokWhTP++iSE1aKXq371xhw1FxnyWL2=pA@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17252: Alter Column Length with dependent Views  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения
On Thu, Oct 28, 2021 at 5:46 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      17252
Logged by:          Javad Ashraf
Email address:      javad_ashraf@hotmail.com
PostgreSQL version: 11.0
Operating system:   Windows
Description:       

In postgres its very bad process to alter column length in table that first
need to drop all dependencies and then alter length and then create again.
Developer also need to take care of order when dropping and recreating, It
should be automated to save developer time.

The absence of such a feature is not a bug - and the effort needed in order to do so doesn't seem generally worth it for a practice that is considered unwise (i.e., just use text and add constraints).

I do agree the feature would be useful - even just to more easily rebuild views that are used by other views (also considered unwise) - but finding volunteers to implement it doesn't seem likely, IMO.

David J.

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: BUG #17251: Download Link Page Displaying Weirdly
Следующее
От: Noah Misch
Дата:
Сообщение: Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data