django.db.utils.ProgrammingError: type "hstore" does not exist

Question

Hi guys so I know this question has been asked many times but the solution that have been provided doesn't seem to fix the source of my problem.

Based on what I've seen the solution is to run create extension hstore.

However, I get the error django.db.utils.ProgrammingError: type "hstore" does not exist when I'm trying to run a django test, ie python manage.py test test_function

I'm not familiar with django tests but from what I'm seeing with the codebase I am working with is that the django test is creating a test database when I run the django test command.

When I checkout what extensions are available with the test database with \dx I see that it does not have hstore. If I run create extension hstore then the hstore extension gets created. Problem is that whenever I rerun the django test, python manage.py test test_function it tells me the test database already exists and I need to delete it first otherwise the command exits. By deleting the database the extension that just got added also gets removed thus when I run python manage.py test test_function again I end up with the same error.

How do I get rid of the error? Thank you.

You can use the HStoreExtension migration to add the extension as part of your migrations if your user has the correct privileges docs.djangoproject.com/en/3.1/ref/contrib/postgres/operations/… — Iain Shelvington
– Iain Shelvington, Commented Apr 13, 2021 at 23:34

Mark · Accepted Answer · 2021-04-14 18:25:26Z

7

Turns out what I needed to do was create the hstore extension to the default template1 with:

psql template1 -c 'create extension hstore;'

answered Apr 14, 2021 at 18:25

Mark

3,8585 gold badges29 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

vinyll Over a year ago

Thanks you for sharing your solution, it saved me. For next users, "template1" should be relaplaced with the name of your database.

Collectives™ on Stack Overflow

django.db.utils.ProgrammingError: type "hstore" does not exist

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related