Huabing wrote:

I have following trigger statement: CREATE TRIGGER delete_pos_cp AFTER DELETE ON cp referencing old row as o FOR EACH ROW WHEN o.new_id_ IS NOT NULL UPDATE cp SET old_id_ = o.old_id_ WHERE rec_id_ = o.rec_id_;

Following error is issued: SELECT: identifier 'rec_id_' ambiguous That could be correct. rec_id belongs to table and its correlated one. use cp.rec_id_ or o.rec_id_o

The last "o.rec_id_" gives rise to this ambigious. Any suggestion on this.

------------------------------------------------------------------------------ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users