I have a question as to the best use of LoadData. I’m on LQB 1.9.5 and Postgres 8.3/4. It works great for an initial data load, however since the CSV is calculated into the md5 sum, modifying the CSV later and using it in a new changeset that refreshes the tables doesn’t work because of a checksum violation. I’ve tried adding to the changesets that load the data, but it still fails checksum validation. Here’s what that changeset looks like:
delete from errors;
I tried taking advantage of the fact that the CSV is part of the md5 sum and setting runOnChange to true. That worked, but not in all cases since runOnChange changesets run after everything else, and sometime migrations rely on data previously loaded.
So I’m still kinda stuck. Is there a good workaround for this short of clearing the checksum?