I am having trouble with a trigger. What I am trying to accomplish is to maintain a table in 2 databases on separate machines. (No, ER is not a possibility we are running HDR to another machine).
When the insert trigger fires we get:
-747 Table or column matches object referenced in triggering statement
Below is the schema (the same on both) and the trigger on machine A

create table security (
security_id SERIAL not null,
cusip CHAR(11),
iss_id INT,
sec_type CHAR(1) not null,
symbol CHAR(12) not null,
exch_code CHAR(1),
creation_date DATE not null,
death_date DATE
)

CREATE TRIGGER ins_security INSERT ON security
REFERENCING NEW AS post_ins
FOR EACH ROW(
INSERT INTO mrstock@qadbs1:security values(post_ins.security_id,
post_ins.cusip, post_ins.iss_id, post_ins.sec_type,
post_ins.symbol, post_ins.exch_code,
post_ins.creation_date, post_ins.death_date));

Dale R. Gilbert
Sr. Database Analyst
(310) 385-2125
E-MAIL DISCLAIMER
Notice Regarding Entry of Orders: Please do not transmit orders regarding your account(s) by e-mail. National Clearing Corp. will not accept orders transmitted by e-mail, and National Clearing Corp. will not be responsible for carrying out such orders.
Notice Regarding Privacy and Confidentiality: National Clearing Corp. reserves the right to monitor and review the content of all e-mail communications sent and/or received by its employees.

sending to informix-list