SEO

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

Dale Gilbert wrote:

> 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

Upgrade to 9.40. You can then mix and match ER and HDR.

> 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));

--
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche