dolthub / dolthub/doltgresql

dolt_verify_constraints doesn't work for foreign keys

Open
#2,238 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
2.1k
Forks
73
Avg merge
1d 10h
Merged PRs (30d)
129

Description

`select dolt_verify_constraints()` does not work to check foreign keys because we are serializing or parsing some the constraint with the wrong dialect:

```sql
select dolt_verify_constraints();
ERROR: error calculating constraint violations: at or near "credential_references_id_unique": syntax error
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.