Re: Change view ownership

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)