Revision 2630
Added by Jing Tao about 19 years ago
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
Fixed bug in the trigger of xml_path_index table