Brian Hirt 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

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 4 of 4 | next ›
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedAug 13, '13 at 4:55p
activeAug 13, '13 at 9:33p
posts4
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Tom Lane: 2 posts Brian Hirt: 2 posts

People

Translate

site design / logo © 2018 Grokbase