Re: insert into select from

"Jan Branbergen" <jan@entrisphere.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