Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[hydra] add foreign key constraint for the parsing_table column #231

Open
bolinocroustibat opened this issue Dec 5, 2024 · 1 comment
Open

[hydra] add foreign key constraint for the parsing_table column #231

bolinocroustibat opened this issue Dec 5, 2024 · 1 comment
Assignees
@bolinocroustibat

Comments

@bolinocroustibat
Copy link
Contributor

bolinocroustibat commented Dec 5, 2024 •
edited
Loading

This follows PR discussions on #229:

Add a foreign key constraints for parsing_table column of checks table as was done in #195, but to a table name.
@bolinocroustibat bolinocroustibat self-assigned this Dec 5, 2024
@bolinocroustibat bolinocroustibat transferred this issue from datagouv/data.gouv.fr Dec 5, 2024
@bolinocroustibat bolinocroustibat mentioned this issue Dec 5, 2024
Merged
@bolinocroustibat bolinocroustibat changed the title [hydra] add foreign key constraint to the table_name as the parsing_table column [hydra] add foreign key constraint for the parsing_table column Dec 5, 2024
@bolinocroustibat
Copy link
Contributor Author

A foreign key must references a key in the local database, but the parsing tables are in a second database (the CSV database, on a different port 5434), so it seems impossible to do so.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@bolinocroustibat bolinocroustibat

Labels
None yet
Projects
🚀 Produit data.gouv.fr
Status: 📝 Todo
Milestone
No milestone
Development

No branches or pull requests
1 participant
@bolinocroustibat