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

Fix too long index names #25

Closed
roskakori opened this issue Apr 16, 2020 · 0 comments · Fixed by #26
Closed

Fix too long index names #25

roskakori opened this issue Apr 16, 2020 · 0 comments · Fixed by #26
Assignees
@roskakori
Labels
bug Something isn't working
Milestone
0.2.0

Comments

@roskakori
Copy link
Owner

Some index names get too long for PostgreSQL, which by default has a limit of 63.
@roskakori roskakori added the bug Something isn't working label Apr 16, 2020
@roskakori roskakori added this to the 0.2.0 milestone Apr 16, 2020
@roskakori roskakori self-assigned this Apr 16, 2020
roskakori added a commit that referenced this issue Apr 16, 2020
@roskakori
#25 Fixed command "build" for PostgreSQL:
e27c726 
* Index names now have at most 63 characters under PostgreSQL. Proper limits should also be in place for MS SQL and Oracle but have yet to be tested. SQLite always worked because it has a very large limit.
* The PostgreSQL docker container for the test run now has more shared memory in order to allow "insert ... from select ..." with millions of rows. Performance still has a lot of room for improvement.
@roskakori roskakori mentioned this issue Apr 16, 2020
Merged
roskakori added a commit that referenced this issue Apr 16, 2020
@roskakori
Merge pull request #26 from roskakori/3-add-tv-episodes
d730b0e 
#3 + #25 Add TV episodes, fix command "build" for postgres
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@roskakori roskakori

Labels
bug Something isn't working
Projects
None yet
Milestone
0.2.0
Development

Successfully merging a pull request may close this issue.

#3 + #25 Add TV episodes, fix command "build" for postgres roskakori/pimdb
1 participant
@roskakori