Comment 4 for bug 1937294

Revision history for this message
Jason Stephenson (jstephenson) wrote :

It tuns out that at least the hold targeter test fails because the way we load test data depends on undefined behavior in PostgreSQL that has not changed from Pg 9.4 through Pg 10. Unfortunately, for us, that behavior has changed in Pg 11.

We need a more robust way to load the test data. I am inclined to starting by dumping the data from fresh loads on Pg 10 and using the resulting copy files.

The big issue with this will be keeping the test data up to date with schema changes. It may require developers to load the test database schema, run the db upgrade scripts, and then dump the data again. This could be scripted/programmed.