"Jan Branbergen" <jan(at)entrisphere(dot)com> writes:
> When i do a "NSERT INTO screen_filter_field( screen_filter_id,
> screen_field_id, seqno, visible, orderno ) SELECT 182, id, seqno, visible,
> orderno FROM screen_field WHERE screen_id = 1" i get a permission denied on
> table screen_field; i have select, insert, update & delete access to table
> screen_filter_field, and select access to table b. when i add update access
> to table b, the statement executes fine.
I can't duplicate this. Perhaps you have rules or triggers you didn't
tell us about?
regards, tom lane