Re: View permission error after upgrading from 8.4 -> 9.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: View permission error after upgrading from 8.4 -> 9.2
Date
Msg-id 19755.1376429625@sss.pgh.pa.us
Whole thread Raw
In response to Re: View permission error after upgrading from 8.4 -> 9.2  (Brian Hirt <bhirt@me.com>)
List pgsql-general
Brian Hirt <bhirt@me.com> writes:
> None of the relations used by vcredit_info are views.   They are all
> tables.   Oddly, I dropped the view and recreated it and the problem went
> away.  Earlier I was just using create or replace view and the problem
> persisted.

Hm.  I think that CREATE OR REPLACE VIEW may not change the view owner,
so the behavior would be explainable if the view's original owner did
not have permissions to read that table.

            regards, tom lane


pgsql-general by date:

Previous
From: Michael Cronenworth
Date:
Subject: Re: MinGW compiled client library
Next
From: Robert James
Date:
Subject: Materializing a view by hand