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
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
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