Fix refresh of primer_search view

MullinsLab / viroverse

a platform for the collection, storage, retrieval, and analysis of experimental data for laboratory workflows

MIT License

5 stars 1 forks source link

Fix refresh of primer_search view #71

Closed silby closed 5 years ago

silby commented 5 years ago

{UNKNOWN}: DBI Exception: DBD::Pg::db do failed: ERROR:  cannot refresh materialized view "viroserve.primer_search" concurrently
HINT:  Create a unique index with no WHERE clause on one or more columns of the materialized view.
CONTEXT:  SQL function "refresh_primer_search" statement 1 at /home/vverse/viroverse/scripts/refresh-materialized-view line 28