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

create fec_fitem_sched_a/b_2019_2020 partition tables and related objects #3657

Closed
2 tasks done
fecjjeng opened this issue Mar 28, 2019 · 1 comment
Closed
2 tasks done
Assignees
Milestone

Comments

@fecjjeng
Copy link
Contributor

fecjjeng commented Mar 28, 2019

With new cycle 2019_2020, partition for tables disclosure.fec_fitem_sched_a/b for the new cyclde (disclosure.fec_fitem_sched_a/b_2019_2020). The tables were already created as part of the Java transfer process when it first encountered the incoming data for cycle 2019/2020 so we will not miss any incoming data. However, official migration script is need to add these to the version controlled base of the database structure.

  • create migration script to "officially" add these new partition tables disclosure.fec_fitem_sched_a/b_2019_2020
  • update index creation functions for these two tables to simplify the index creation when new child partition tables are created.
@hcaofec
Copy link
Contributor

hcaofec commented Apr 23, 2019

close this ticket since PR is merged.

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

No branches or pull requests

3 participants