We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
There was an error while loading. Please reload this page.
1 parent 607311f commit 7291c02Copy full SHA for 7291c02
coderd/database/migrations/000296_organization_soft_delete.up.sql
@@ -9,7 +9,7 @@ CREATE UNIQUE INDEX IF NOT EXISTS idx_organization_name_lower ON organizations U
9
ALTER TABLE ONLY organizations
10
DROP CONSTRAINT IF EXISTS organizations_name;
11
12
-CREATE FUNCTION protect_deleted_organizations()
+CREATE FUNCTION protect_deleting_organizations()
13
RETURNS TRIGGER AS
14
$$
15
DECLARE
@@ -78,7 +78,7 @@ END;
78
$$ LANGUAGE plpgsql;
79
80
-- Trigger to protect organizations from being soft deleted with existing resources
81
-CREATE TRIGGER protect_deleted_organizations
+CREATE TRIGGER protect_deleting_organizations
82
BEFORE UPDATE ON organizations
83
FOR EACH ROW
84
WHEN (NEW.deleted = true AND OLD.deleted = false)
0 commit comments