Postgresql hstore extension not initialized in testing

[David Vogt]

I'm using pytest-django, so I'm not 100% sure this belongs here or with pytest-django itself, but nonetheless:

In one of my projects, I'm using HStore fields from the django.contrib.postgres package. The HStore extension needs to be registered with psycopg2 on a per-connection basis. changeset:f7b0532ec0cf703849ef (as a followup to changeset:86a18dc46a) skips registering on "unknown" databases, which then leads to the extension missing when running tests.

It seems that the extension is properly registered when creating the DB for each test run, but not when reusing it.

The current workaround is a custom signal handler on connection_created to call psycopg2.exttras.register_hstore() explicitly (without OID parameters, so it forces auto-detection).

[Tim Graham]

This ticket tracker isn't a support channel to get help debugging your issue. Can you please investigate it and determine whether or not Django is at fault (or get help at TicketClosingReasons/UseSupportChannels)? At the very least, you should provide a sample project with steps to reproduce the issue (and one that doesn't use pytest-django, to rule out an issue there).