From: | Brian Hirt <bhirt(at)me(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: View permission error after upgrading from 8.4 -> 9.2 |
Date: | 2013-08-13 20:19:47 |
Message-ID: | 12a38a55-24cb-4623-af45-45fed42b11be@me.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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. The schema was created by using pg_restore from an 8.4 custom dump. I can do another pg_restore and see if the problem is reproducible if you want.
On Aug 13, 2013, at 12:03 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
Brian Hirt <bhirt(at)me(dot)com> writes:
I'm upgrading our database from 8.4 to 9.2 and I've run across a view that is no longer working. � When selecting from the view, I get a permission denied error on one of the referenced tables. � However, I can run the view's query directly without problems and I have read access to all the tables the view accesses.
Permissions checks for tables referenced by a view are done as the view's
owner. I'm suspicious that one of the relations used in your view
vcredit_info is itself a view that references developer_title, and
is owned by some other user with less privilege than you.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Barth Weishoff | 2013-08-13 20:51:18 | Debugging Postgres? |
Previous Message | Adrian Klaver | 2013-08-13 20:00:16 | Re: Please help |