Re: BUG #3265: 8.1 -> 8.2 behviour change: View owner must have access to underlying tables - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3265: 8.1 -> 8.2 behviour change: View owner must have access to underlying tables
Date
Msg-id 7186.1178774124@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3265: 8.1 -> 8.2 behviour change: View owner must have access to underlying tables  ("Russell Smith" <mr-russ@pws.com.au>)
Responses Re: BUG #3265: 8.1 -> 8.2 behviour change: View owner must have access to underlying tables  (Russell Smith <mr-russ@pws.com.au>)
List pgsql-bugs
"Russell Smith" <mr-russ@pws.com.au> writes:
> CREATE view v1 as select * from t1;
> ALTER TABLE v1 OWNER TO "USER";

See thread here:
http://archives.postgresql.org/pgsql-hackers/2006-04/msg01138.php
and patch here:
http://archives.postgresql.org/pgsql-committers/2006-09/msg00101.php

This was not back-patched because it seemed like too much of a behavior
change for stable branches.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Adam Kunen"
Date:
Subject: Re: BUG #3264: SPI: int64's sometimes returned by value sometimes by reference
Next
From: "Jack Ho"
Date:
Subject: Is PostgresSQL supported in Windows Vista?