Skip to content

Test without change#1485

Closed
chdsbd wants to merge 2 commits intomainfrom
test-without-change
Closed

Test without change#1485
chdsbd wants to merge 2 commits intomainfrom
test-without-change

Conversation

@chdsbd
Copy link
Copy Markdown
Collaborator

@chdsbd chdsbd commented Jun 10, 2024

No description provided.

@github-actions
Copy link
Copy Markdown

github-actions bot commented Jun 10, 2024

Squawk Report

🚒 1 violations across 1 file(s)

backend/recipeyak/migrations/0134_recipefavorite_recipe_user_uniq.sql

BEGIN;
--
-- Create constraint recipe_user_uniq on model recipefavorite
--
ALTER TABLE "recipe_favorite" ADD CONSTRAINT "recipe_user_uniq" UNIQUE ("recipe_id", "user_id");
COMMIT;

🚒 Rule Violations (1)

backend/recipeyak/migrations/0134_recipefavorite_recipe_user_uniq.sql:2:1: warning: disallowed-unique-constraint

   2 | --
   3 | -- Create constraint recipe_user_uniq on model recipefavorite
   4 | --
   5 | ALTER TABLE "recipe_favorite" ADD CONSTRAINT "recipe_user_uniq" UNIQUE ("recipe_id", "user_id");

  note: Adding a UNIQUE constraint requires an ACCESS EXCLUSIVE lock which blocks reads.
  help: Create an index CONCURRENTLY and create the constraint using the index.

📚 More info on rules

⚡️ Powered by Squawk (0.29.0), a linter for PostgreSQL, focused on migrations

@chdsbd chdsbd mentioned this pull request Jun 10, 2024
Merged
@sbdchd sbdchd closed this Sep 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

2 participants

@chdsbd @sbdchd