"Jan Branbergen" <jan@entrisphere.com> writes:
> i have constraints defined on the tables to force ref integrity, but nothing
> else. i can send my schema if you would like.
If you have a foreign key reference from screen_filter_field to
screen_filter, that would explain it --- but I'd expect you'd be
seeing the permissions issue on any insert into screen_filter_field,
not only an INSERT/SELECT.
See past discussions about why the foreign key triggers use SELECT FOR
UPDATE rather than plain SELECT. I am not sure whether this is any
different in 7.1 ...
regards, tom lane
