"Andrew White" <[EMAIL PROTECTED]> writes: > I came across an interesting issue regarding views and ownership that I > think may be a bug in PG. I am using PG 8.2.3 on SuSE Linux.
AFAICS this is behaving as intended, because you did not grant select on the underlying table to the owner of the view. Relation references in a view are supposed to be checked according to the view owner's permissions. This did not always work right pre-8.2, see http://archives.postgresql.org/pgsql-hackers/2006-04/msg01138.php regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster