Changeset 3859
- Timestamp:
- 07/05/08 13:00:10 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
TI01-discovery/branches/ingestAutomation-upgrade/database/ingest_procedures.sql
r3851 r3859 42 42 43 43 DROP FUNCTION update_document(original_document_id_in int, filename_in varchar(255), 44 discovery_id_in varchar(255), doc_type_in text, original_document_in text, scn_in tint) CASCADE;44 discovery_id_in varchar(255), doc_type_in text, original_document_in text, scn_in int) CASCADE; 45 45 CREATE FUNCTION update_document(original_document_id_in int, filename_in varchar(255), 46 discovery_id_in varchar(255), doc_type_in text, original_document_in text, scn_in tint)47 RETURNS integerAS46 discovery_id_in varchar(255), doc_type_in text, original_document_in text, scn_in int) 47 RETURNS VOID AS 48 48 $$ 49 49 DECLARE 50 scn_current integer := 1;50 scn_current integer; 51 51 BEGIN 52 52 -- This updates an existing document 53 53 54 54 -- check the scn is valid before an update is done 55 55 SELECT scn INTO scn_current FROM ORIGINAL_DOCUMENT WHERE 56 56 original_document_id = original_document_id_in; 57 57 IF scn_in <> scn_current THEN 58 RAISE EXCEPTION 'Invalid SCN specified (current scn=%, specified scn=%) - implies record has been changed during update - exiting...'; 58 RAISE EXCEPTION 'Invalid SCN specified (current scn=%, specified scn=%) - 59 implies record has been changed during update - exiting...', scn_current, scn_in; 59 60 END IF; 60 61
Note: See TracChangeset
for help on using the changeset viewer.