[MonetDB-users] strange trigger behaviour

Hi guys,

I have created a table named users: CREATE TABLE names

(     name VARCHAR(255) NOT NULL );

another table named names2 which is same as users. only table names are different. I have created a after insert trigger like this:

CREATE TRIGGER trg_names_ai AFTER INSERT ON names REFERENCING NEW ROW AS new_row FOR EACH ROW WHEN new_row.name = '<some name>' INSERT INTO names2 VALUES(new_row.name);

The problem is it doesn't care about WHEN clause. Any INSERT query will appear in names2. Can anyone help?