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 1160530393.5716.67.camel@localhost.localdomain
Whole thread Raw
In response to Re: 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:27 -0500, Jim C. Nasby wrote:
> Wow, that's news to me. I'll prepare a docs patch to reflect that.

It is already reflected in the docs, although it might need to be more
prominent.

> Is there any other operations ALTER TABLE can perform on a view?

IIRC, it can be used to rename an index, sequence, or view, and also to
add defaults to a view's columns.

-Neil

pgsql-hackers by date:

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