Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?

From: ash <ash(at)commandprompt(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?
Date: 2014-05-26 14:25:09
Message-ID: 87mwe4k46y.fsf@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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@mail.gmail.com

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2014-05-26 14:34:18 Re: Spreading full-page writes
Previous Message Fujii Masao 2014-05-26 14:16:55 Re: Priority table or Cache table