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

update tsvector column trigger defs for table sa7 #3834

Closed
jason-upchurch opened this issue Jun 25, 2019 · 3 comments · Fixed by #4095
Closed

update tsvector column trigger defs for table sa7 #3834

jason-upchurch opened this issue Jun 25, 2019 · 3 comments · Fixed by #4095
Assignees
@jason-upchurch
Labels
Bug Needs prioritization
Milestone
Sprint 10.6

Comments

@jason-upchurch
Copy link
Contributor

jason-upchurch commented Jun 25, 2019 •
edited
Loading

Problem

From related issue #3798, varchar columns with corresponding searchable tsvector columns should have special characters stripped and the tsvector column parsed in a way that lends itself to consistent searching.

affected table column
sa7 contributor_name_text
sa7 contributor_employer_text
sa7 contributor_occupation_text
@jason-upchurch jason-upchurch self-assigned this Nov 19, 2019
@jason-upchurch jason-upchurch added this to the Sprint 10.6 milestone Nov 19, 2019
@jason-upchurch jason-upchurch mentioned this issue Nov 19, 2019
Closed
2 tasks
@jason-upchurch
Copy link
Contributor Author

jason-upchurch commented Nov 19, 2019 •
edited
Loading

rediscovered this issue due to #4085. Beginning work. Refer to #3811 for template (cc @PaulClark2 @fecjjeng )

@jason-upchurch jason-upchurch mentioned this issue Nov 19, 2019
Closed
2 tasks
@jason-upchurch
Copy link
Contributor Author

This table (along with other raw efile tables) are populated directly by another process/contract. Will discuss with COR for next steps (cc @fecjjeng @PaulClark2 )

This was referenced Nov 20, 2019
Closed
Merged
@jason-upchurch
Copy link
Contributor Author

Testing issue under #4085 (original bug report)

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

@jason-upchurch jason-upchurch

Labels
Bug Needs prioritization
Projects
None yet
Milestone
Sprint 10.6
Development

Successfully merging a pull request may close this issue.

Feature/3834 tsvector sa7 fecgov/openFEC
1 participant
@jason-upchurch