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 <t...@sss.pgh.pa.us> wrote: Brian Hirt <bh...@me.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
