Re: [BUGS] insert into select from

2001-05-04 Thread Tom Lane
"Jan Branbergen" <[EMAIL PROTECTED]> 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 sele

Re: [BUGS] insert into select from

2001-05-04 Thread Tom Lane
"Jan Branbergen" <[EMAIL PROTECTED]> 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