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

On Thu, Oct 28, 2021 at 5:46 AM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 17252
> Logged by: Javad Ashraf
> Email address: javad_ashraf(at)hotmail(dot)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.