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