Jay Brown
12 lines
481 B
SQL
12 lines
481 B
SQL
-- Rollback migration 130: drop both triggers, then both functions.
|
|
-- Triggers must go before their functions or DROP FUNCTION complains
|
|
-- about dependent objects.
|
|
|
|
DROP TRIGGER IF EXISTS trg_prevent_legacy_extraction_on_custom_document
|
|
ON documentFieldExtractions;
|
|
DROP TRIGGER IF EXISTS trg_prevent_schema_reassignment
|
|
ON documents;
|
|
|
|
DROP FUNCTION IF EXISTS trg_prevent_legacy_extraction_on_custom_document();
|
|
DROP FUNCTION IF EXISTS trg_prevent_schema_reassignment();
|