Re: [BUGS] INSERT INTO ... SELECT

2004-04-07 Thread Tom Lane
Jiang Wei <[EMAIL PROTECTED]> writes: > =>create table empty(); > =>insert into empty default values; > =>insert into empty select * from empty; > server crash. Fixed, thanks for the report. regards, tom lane Index: execJunk.c ===

[BUGS] INSERT INTO ... SELECT

2004-04-07 Thread Jiang Wei
=>create table empty(); =>insert into empty default values; =>insert into empty select * from empty; server crash. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

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

[BUGS] insert into select from

2001-05-04 Thread Jan Branbergen
POSTGRESQL BUG REPORT TEMPLATE Your name : Jan Branbergen Your email address : [EMAIL PROTECTED]