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

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: ash <ash(at)commandprompt(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?
Date: 2014-05-28 13:55:13
Message-ID: 20140528135513.GY2556@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* ash (ash(at)commandprompt(dot)com) wrote:
> What I am suggesting is that we try to detect such breakage at the time
> the user runs ALTER TABLE (issuing NOTICE or ERROR at user discretion.)
> If changing column type of a table breaks some functions down the way,
> the user will hit it anyway, but better know it soon than when he wants
> to *run* that function.

Sure, if we had the information about what would break then we could
tell the user about it. We don't and that's not likely to ever
change...

Thanks,

Stephen

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabrízio de Royes Mello 2014-05-28 14:01:43 Re: pg_llog not mentioned in "Database File Layout"
Previous Message Andres Freund 2014-05-28 13:49:01 Re: pg_llog not mentioned in "Database File Layout"