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.

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

Multiple foreign key constraints created #72

Open
davenquinn opened this issue Jul 25, 2024 · 1 comment
Open

Multiple foreign key constraints created #72

davenquinn opened this issue Jul 25, 2024 · 1 comment

Comments

@davenquinn
Copy link
Member

Some of our code for adding foreign key constraints to the macrostrat schema is creating multiple constraints. I assume this is due to re-running ALTER TABLE statements without checking existence. One way to address this would be to set a certain name for the foreign key constraint, rather than just allowing it to be named dynamically on table creation.

Screenshot 2024-07-25 at 5 16 30 AM
@davenquinn
Copy link
Member Author

The culprit appears to be here

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant