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: Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2014-05-28T18:16:48Z
Lists: pgsql-hackers
* ash (ash@commandprompt.com) wrote:
> OK, forget functions, I now realize it's not feasible to consider.

I never meant to imply that it was but rather to point out that we might
have users who actually want to get an error when they're changing a
type definition which goes beyond the scope of the explicit action (and
therefore could very well have more side-effects than they realize),
rather than just doing it for them.

> Can we get back to re-defining views at least?

I'm still not convinced you'll be able to do it in a sensible and
reliable way, but you're certainly welcome to continue exploring.

	Thanks,

		Stephen

Commits

  1. Allow CREATE OR REPLACE VIEW to add columns to the _end_ of the view.