| From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE? |
| Date: | 2014-05-28 02:39:18 |
| Message-ID: | 1401244758646-5805191.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Alexander Shulgin wrote
> Hi Hackers,
>
> This came up recently on general list (and I've just hit the same issue
> today):
> http://www.postgresql.org/message-id/
> CAB7nPqTLmMn1LTb5WE0v0dO57iP0U73yKwzbZytAXDF1CAWLZg(at)(dot)gmail
>
> Why couldn't postgres re-create the dependent views automatically? I
> mean it knows which views depend on the altered column and keeps the
> view definition, no?
>
> Would a patch likely to be accepted? How hard do you feel this might be
> to implement? Any caveat that defeats the purpose of such feature?
>
> Thanks.
Would it be possible to handle the specific case of varchar(n) to
varchar/text by just ignoring the error?
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Re-create-dependent-views-on-ALTER-TABLE-ALTER-COLUMN-TYPE-tp5804972p5805191.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ash | 2014-05-28 03:20:52 | Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE? |
| Previous Message | Tom Lane | 2014-05-28 02:37:22 | Re: [PATCH] Replacement for OSSP-UUID for Linux and BSD |