MySQL Forums
Forum List  »  Falcon

Does Falcon support triggers - or should I be worried
Posted by: Ken Brown
Date: April 06, 2009 03:33AM

Got a table with a before insert trigger but it does not fire - even when I change the trigger code below to constants

Does Falcon support triggers or am I missing something

DDL and DML extract
CREATE TABLE IF NOT EXISTS `Plan`.`P_SEC_OBJ` (
`SEC_OBJ_PK` INT UNSIGNED NOT NULL ,
`SESSION_ID` INT UNSIGNED NOT NULL ,
`CREATE_NAME` VARCHAR(45) NOT NULL ,
`CREATE_STAMP` DATETIME NOT NULL ,
`UPDATE_NAME` VARCHAR(45) NOT NULL ,
`UPDATE_STAMP` DATETIME NOT NULL
`SEC_OBJ` VARCHAR(45) NOT NULL ,
PRIMARY KEY (`SEC_OBJ_PK`) )
ENGINE = Falcon;
create trigger tbi_P_SEC_OBJ
before insert on P_SEC_OBJ
for each row
begin
set new.sec_obj_pk = getseq('GEN');
set new.session_id = getseq('GEN');
set new.create_name = current_user();
set new.create_stamp = now();
set new.update_name = current_user();
set new.update_stamp = now();
end;
insert into p_sec_obj (SEC_OBJ) VALUES ('aaa');

fails saying sec_obj_pk not set - even tried removing getseq to a constant - same problem. Doesn't look like trigger is firing at all.

Options: ReplyQuote


Subject
Written By
Posted
Does Falcon support triggers - or should I be worried
April 06, 2009 03:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.