Re: insert into select from

"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