Project

General

Profile

« Previous | Next » 

Revision 2630

Added by Jing Tao over 18 years ago

Fixed bug in the trigger of xml_path_index table

View differences:

src/xmltables.sql
332 332
        CONSTRAINT xml_path_index_docid_fk FOREIGN KEY (docid) REFERENCES xml_documents
333 333
 );                                                                                        
334 334

  
335

  
335 336
/*
336
 * create sequence
337
 * create sequence an trigger
337 338
 */
338
CREATE SEQUENCE xml_path_index_id_seq;
339
                                                                                                                                                             
339
CREATE SEQUENCE xml_path_index_id_seq;                                                                                                                                                             
340 340
CREATE TRIGGER xml_path_index_before_insert
341 341
BEFORE INSERT ON xml_path_index FOR EACH ROW
342 342
BEGIN
343 343
  SELECT xml_path_index_id_seq.nextval
344
    INTO :new.relationid
344
    INTO :new.nodeid
345 345
    FROM dual;
346 346
END;
347 347
/

Also available in: Unified diff