SELECT typarray FROM pg_type WHERE typname = 'citext'

Question

SELECT typarray FROM pg_type WHERE typname = 'citext'

Why I am getting this query in django debug panel and what does it mean? Whenever I navigate to the new page, this query gets run as 1st then all others, same thing in the python shell using connection.queries command. I am using django 1.11 and postgres 9.6.

iklinac · Accepted Answer · 2017-12-13T02:37:45.000

1

citex is a PostgreSQL extension and has no fixed typarray so the following query needs to be executed to query pg_type on Django side to register extension with psycopg2

Why you see this query being executed each time you load page is because it is not cached internally which seems to be sorted for Django 2.0

Also note that following query is not called for Django versions before 1.11 as citext is implemented in Django around version 1.11.

edited Dec 13 '17 at 02:37

answered Dec 13 '17 at 02:32

iklinac

14,944
4
28
30

1

Hvala na odgovoru. – Horion Dec 13 '17 at 02:42
You are welcome, here you can see the culprit code :) https://github.com/django/django/blob/stable/1.11.x/django/contrib/postgres/signals.py – iklinac Dec 13 '17 at 02:45

SELECT typarray FROM pg_type WHERE typname = 'citext'

1 Answers1