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

Group CREATE TABLE statements #68

Open
grzegorzk opened this issue Jun 26, 2019 · 2 comments
Open

Group CREATE TABLE statements #68

grzegorzk opened this issue Jun 26, 2019 · 2 comments

Comments

@grzegorzk
Copy link

When some tables reference each other through foreign keys it would be good to first issue CREATE TABLE statements and then, once all tables had been created, add any constraints/foreign keys.

@grzegorzk
Copy link
Author

grzegorzk commented Jul 1, 2019

There is more fundamental issue with statements generated by the tool that rely each on other.

Example - I can have some functions that operate on tables and some other functions that I then use to build indexes and if order of CREATE statements is incorrect then the script will fail.

Not to mention one function may depend on another function.

@hazardland
Copy link
Contributor

@grzegorzk did you solve this case?

I have similar issue: table_child references table_parent with foreign key but table_child is created first and then table_parent

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

2 participants