PIMS-1775: Re-sequencing postgres tables - Githubissues

bcgov / PIMS

Property Inventory Management System

https://pims.gov.bc.ca

Apache License 2.0

47 stars 43 forks source link

PIMS-1775: Re-sequencing postgres tables #2468

Closed LawrenceLau2020 closed 3 months ago

LawrenceLau2020 commented 3 months ago

## 🎯 Summary [PIMS-1775: ](https://citz-imb.atlassian.net/browse/PIMS-1775)

Added a "custom" query (to set sequences for Postgres tables) to run at the end of both ETL tasks
Also, set the table mapping to skip.

It seemed to work locally, but will need to run this on other machines and dev/test to confirm.

🔰 Checklist

[x] I have read and agree with the following checklist and am following the guidelines in our Code of Conduct document.

I have performed a self-review of my code.

I have commented my code, particularly in hard-to-understand areas.

I have made corresponding changes to the documentation where required.

I have tested my changes to the best of my ability.

My changes generate no new warnings.