reject_delete_value()

Description

Trigger function that rejects deletion of variable_values rows unless the entire document is being deleted.

Parameters

Search:

Name	Type	Mode
		IN

Showing 1 to 1 of 1 entries

Definition

 
BEGIN
    IF EXISTS (SELECT 1 FROM documents WHERE id = OLD.document_id) THEN
        RAISE 'This table does not allow deletes.';
    ELSE
        -- The entire document is being deleted.
        RETURN OLD;
    END IF;
END;