launchpad-reviewers team mailing list archive
-
launchpad-reviewers team
-
Mailing list archive
-
Message #32516
[Merge] ~enriqueesanchz/launchpad:update-bugattachment-reference-constraint-hot into launchpad:master
Enrique Sánchez has proposed merging ~enriqueesanchz/launchpad:update-bugattachment-reference-constraint-hot into launchpad:master.
Commit message:
DB hot patch: validate constraint data
Validate exactly_one_reference constraint data
Requested reviews:
Launchpad code reviewers (launchpad-reviewers)
For more details, see:
https://code.launchpad.net/~enriqueesanchz/launchpad/+git/launchpad/+merge/485989
--
Your team Launchpad code reviewers is requested to review the proposed merge of ~enriqueesanchz/launchpad:update-bugattachment-reference-constraint-hot into launchpad:master.
diff --git a/database/schema/patch-2211-38-1.sql b/database/schema/patch-2211-38-1.sql
new file mode 100644
index 0000000..e1dd61e
--- /dev/null
+++ b/database/schema/patch-2211-38-1.sql
@@ -0,0 +1,8 @@
+-- Copyright 2025 Canonical Ltd. This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages=ERROR;
+
+ALTER TABLE bugattachment VALIDATE CONSTRAINT exactly_one_reference;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2211, 38, 1);