Postgres Pro
Downloads
Home   >   mailing lists

Re: Change view ownership - Mailing list pgsql-hackers

From Neil Conway
Subject Re: Change view ownership
Date
Msg-id 1160529814.5716.62.camel@localhost.localdomain
Whole thread Raw
In response to Change view ownership  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: Change view ownership  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-hackers
Tree view 
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

-Neil

pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Change view ownership
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Change view ownership