Re: alter table impact on view

2023-01-30 Thread Marc Millas
A bit sad Thanks.. Le lun. 30 janv. 2023 à 13:53, David Rowley a écrit : > On Tue, 31 Jan 2023 at 01:14, Marc Millas wrote: > > But if I alter table to change a column that is a varchar 20 into a > varchar 21 > > postgres refuse saying that it cannot due to the return rule... using > said colu

Re: alter table impact on view

2023-01-30 Thread David Rowley
On Tue, 31 Jan 2023 at 01:14, Marc Millas wrote: > But if I alter table to change a column that is a varchar 20 into a varchar 21 > postgres refuse saying that it cannot due to the return rule... using said > column > > why ?? as the view is not a materialized object, the impact of the length of

alter table impact on view

2023-01-30 Thread Marc Millas
Hello, to my understanding, if I do alter table rename column, Postgres change the name of the said column, and modify the views using that table so that they keep working (NOT oracle behaviour..) fine. But if I alter table to change a column that is a varchar 20 into a varchar 21 postgres refuse