I cannot create tags in the DB. Getting this error on the back end.
2026-08-07 07:52:45.907 EDT [41239] STATEMENT: INSERT INTO tags (name, color) VALUES ($1, $2) RETURNING *
2026-08-07 08:21:12.125 EDT [42586] ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
2026-08-07 08:21:12.125 EDT [42586] STATEMENT: INSERT INTO plate_tags (plate_number, tag_id)
SELECT $1, id FROM tags WHERE name = $2
ON CONFLICT (plate_number, tag_id) DO NOTHING
2026-08-07 08:24:13.239 EDT [42827] ERROR: null value in column "id" of relation "tags" violates not-null constraint
2026-08-07 08:24:13.239 EDT [42827] DETAIL: Failing row contains (null, Resident, #22c55e, 2026-08-07 08:24:13.239715-04).
2026-08-07 08:24:13.239 EDT [42827] STATEMENT: INSERT INTO tags (name, color) VALUES ($1, $2) RETURNING *
I cannot create tags in the DB. Getting this error on the back end.
2026-08-07 07:52:45.907 EDT [41239] STATEMENT: INSERT INTO tags (name, color) VALUES ($1, $2) RETURNING *
2026-08-07 08:21:12.125 EDT [42586] ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
2026-08-07 08:21:12.125 EDT [42586] STATEMENT: INSERT INTO plate_tags (plate_number, tag_id)
2026-08-07 08:24:13.239 EDT [42827] ERROR: null value in column "id" of relation "tags" violates not-null constraint
2026-08-07 08:24:13.239 EDT [42827] DETAIL: Failing row contains (null, Resident, #22c55e, 2026-08-07 08:24:13.239715-04).
2026-08-07 08:24:13.239 EDT [42827] STATEMENT: INSERT INTO tags (name, color) VALUES ($1, $2) RETURNING *