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>
kjh2064
dc888e7cd0