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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
