Bob Pawley <[EMAIL PROTECTED]> writes: > insert into p_id.loops (monitor) values (new.devices_id) > where new.device_number = library.devices.device_number > and library.devices.type_ = 'mon' ;
Huh? How did library.devices get into this? Are you trying to join to
it, and if so why, seeing that the value you want to insert into
p_id.loops is independent of that table?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
