id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 20198 fixtures.FixtureLoadingTests.test_loaddata_error_message fails on Postgres 9.2 Chris Lawlor nobody "Running the 'fixtures' tests against PostgreSQL 9.2.3 fails as follows: {{{ ====================================================================== FAIL: test_loaddata_error_message (modeltests.fixtures.tests.FixtureLoadingTests) ---------------------------------------------------------------------- Traceback (most recent call last): File ""/home/clawlor/code/django/tests/modeltests/fixtures/tests.py"", line 255, in test_loaddata_error_message management.call_command('loaddata', 'invalid.json', verbosity=0, commit=False) AssertionError: ""Could not load fixtures.Article\(pk=1\): .*$"" does not match ""Problem installing fixture '/home/clawlor/code/django/tests/modeltests/fixtures/fixtures/invalid.json': Could not load fixtures.Article(pk=1): null value in column ""pub_date"" violates not-null constraint DETAIL: Failing row contains (1, Breaking news, null). "" ---------------------------------------------------------------------- }}} The failure is due to the newline in the exception message after the word 'constraint'. The test regex expects a match ending with "".*$"", which does result in a match against a string containing a newline character that is not at the end of the string. This test does not fail against PostgreSQL 9.1. The version of psycopg2 used does not matter. The behavior being tested is clearly not broken, this is a simple matter of updating the test regex. A patch is included which removes the ""$"" requirement. " Bug closed Testing framework dev Normal worksforme Unreviewed 1 0 0 0 0 0