Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?
Stephen Frost <sfrost@snowman.net>
From: Stephen Frost <sfrost@snowman.net>
To: ash <ash@commandprompt.com>
Cc: Robert Haas <robertmhaas@gmail.com>,
"pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2014-05-28T13:55:13Z
Lists: pgsql-hackers
* ash (ash@commandprompt.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
Commits
-
Allow CREATE OR REPLACE VIEW to add columns to the _end_ of the view.
- ff1ea2173a92 8.4.0 cited