0 Releases 32 Tags

RSS Feed

• v2026.08.17.1.dc888e7cd0 dc888e7cd0

  Compare

  fix(0042_iam_tables.sql): Fix PostgreSQL partial unique constraint syntax

  gitea-actions released this 2026-08-17 22:48:50 +09:00 | 17 commits to main since this release

  Issue: Table constraint with WHERE clause is invalid PostgreSQL syntax
  Error: 42601: syntax error at or near "WHERE" at position 1525

  Solution: Move partial uniqueness to separate CREATE UNIQUE INDEX statement

  • Removed invalid WHERE clause from table UNIQUE() constraint
  • Created proper partial unique index with WHERE condition
  • PostgreSQL syntax now correct

  Syntax fix:
  ❌ UNIQUE(col1, col2) WHERE condition (invalid in table def)
  ✅ CREATE UNIQUE INDEX idx ON table(col1, col2) WHERE condition

  Co-Authored-By: Claude Haiku 4.5 noreply@anthropic.com

  Downloads

  • Source Code (ZIP)
  • Source Code (TAR.GZ)