pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17252: Alter Column Length with dependent Views
2+ messages / 2 participants
[nested] [flat]
* BUG #17252: Alter Column Length with dependent Views
@ 2021-10-28 12:05 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2021-10-28 12:05 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: javad_ashraf@hotmail.com
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17252: Alter Column Length with dependent Views
@ 2021-10-28 13:47 David G. Johnston <david.g.johnston@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2021-10-28 13:47 UTC (permalink / raw)
To: javad_ashraf@hotmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-10-28 13:47 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-10-28 12:05 BUG #17252: Alter Column Length with dependent Views PG Bug reporting form <noreply@postgresql.org>
2021-10-28 13:47 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox