| From: | Marc Millas <marc(dot)millas(at)mokadb(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | alter table impact on view |
| Date: | 2023-01-30 12:13:58 |
| Message-ID: | CADX_1aYPNpX2DKS8bP=aU3UgNPQXtv2iKjCbsL8AkxU13486Fg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 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 a column of an underlying table do change the description of the view,
clearly, but I dont see where the difficulty is "hidden". Can someone
enlighten me?
thanks,
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2023-01-30 12:52:51 | Re: alter table impact on view |
| Previous Message | veem v | 2023-01-30 11:29:00 | Re: Sequence vs UUID |