On Tue, Oct 10, 2006 at 09:23:34PM -0400, Neil Conway wrote:
> On Tue, 2006-10-10 at 20:17 -0500, Jim C. Nasby wrote:
> > IIRC there was an intention to allow ownership reassignment of all
> > objects in the database. Somehow views got missed
>
> ALTER TABLE can change view ownership (as well as sequence ownership).
> You could argue for the addition of an ALTER VIEW ... OWNER TO, but IMHO
> it is not something that is urgent enough for inclusion in 8.2
Wow, that's news to me. I'll prepare a docs patch to reflect that.
Is there any other operations ALTER TABLE can perform on a view?
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)