Thank you for psycopg3!!

I'm looking forward to using it in Django; the feature freeze for Django 4.1 is May 17. Were you planning to get ticket 33308 completed / closed by then?

This fixes two Django test suite errors:

======================================================================
ERROR: test_extract_func_with_timezone_minus_no_offset (db_functions.datetime.test_extract_trunc.DateFunctionWithTimeZoneTests) [backports.zoneinfo.ZoneInfo(key='Asia/Ust-Nera')]
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "/home/runner/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 568, in execute
    raise ex.with_traceback(None)
psycopg.errors.InvalidParameterValue: time zone "Asia/Ust+Nera" not recognized

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/tests/db_functions/datetime/test_extract_trunc.py", line 1226, in test_extract_func_with_timezone_minus_no_offset
    utc_model = qs.get()
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/models/query.py", line 437, in get
    num = len(clone)
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/models/query.py", line 262, in __len__
    self._fetch_all()
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/models/query.py", line 1358, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/models/query.py", line 51, in __iter__
    results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/models/sql/compiler.py", line 1234, in execute_sql
    cursor.execute(sql, params)
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/backends/utils.py", line 76, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "/home/runner/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 568, in execute
    raise ex.with_traceback(None)
django.db.utils.DataError: time zone "Asia/Ust+Nera" not recognized

======================================================================
ERROR: test_extract_func_with_timezone_minus_no_offset (db_functions.datetime.test_extract_trunc.DateFunctionWithTimeZoneTests) [<DstTzInfo 'Asia/Ust-Nera' LMT+9:33:00 STD>]
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "/home/runner/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 568, in execute
    raise ex.with_traceback(None)
psycopg.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/tests/db_functions/datetime/test_extract_trunc.py", line 1226, in test_extract_func_with_timezone_minus_no_offset
    utc_model = qs.get()
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/models/query.py", line 437, in get
    num = len(clone)
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/models/query.py", line 262, in __len__
    self._fetch_all()
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/models/query.py", line 1358, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/models/query.py", line 51, in __iter__
    results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/models/sql/compiler.py", line 1234, in execute_sql
    cursor.execute(sql, params)
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/backends/utils.py", line 76, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "/home/runner/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 568, in execute
    raise ex.with_traceback(None)
django.db.utils.InternalError: current transaction is aborted, commands ignored until end of transaction block

See https://github.com/django/django/commit/0f6946495a8ec955b471ca1baaf408ceb53d4796

This should fix 12 occurrencs of error:

ERROR: test_add (many_to_many.tests.ManyToManyTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "django_repo/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
  File "/home/runner/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 555, in execute
    raise ex.with_traceback(None)
psycopg.errors.UniqueViolation: duplicate key value violates unique constraint "many_to_many_article_pub_article_id_publication_i_caad31f7_uniq"
DETAIL:  Key (article_id, publication_id)=(6, 3) already exists.

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "django_repo/tests/many_to_many/tests.py", line 53, in test_add
    a6.publications.add(self.p3)
  File "django_repo/django/db/models/fields/related_descriptors.py", line 1069, in add
    self._add_items(
  File "django_repo/django/db/models/fields/related_descriptors.py", line 1290, in _add_items
    self.through._default_manager.using(db).bulk_create(
  File "django_repo/django/db/models/query.py", line 682, in bulk_create
    returned_columns = self._batched_insert(
  File "django_repo/django/db/models/query.py", line 1586, in _batched_insert
    self._insert(
  File "django_repo/django/db/models/query.py", line 1552, in _insert
    return query.get_compiler(using=using).execute_sql(returning_fields)
  File "django_repo/django/db/models/sql/compiler.py", line 1667, in execute_sql
    cursor.execute(sql, params)
  File "django_repo/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(
  File "django_repo/django/db/backends/utils.py", line 80, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "django_repo/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
  File "django_repo/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "django_repo/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
  File "/home/runner/.local/lib/python3.8/site-packages/psycopg/cursor.py", line 555, in execute
    raise ex.with_traceback(None)
django.db.utils.IntegrityError: duplicate key value violates unique constraint "many_to_many_article_pub_article_id_publication_i_caad31f7_uniq"
DETAIL:  Key (article_id, publication_id)=(6, 3) already exists.

This fixes one Django test suite failure:

======================================================================
ERROR: test_nodb_cursor_reraise_exceptions (backends.postgresql.tests.Tests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/runner/.local/lib/python3.8/site-packages/django_psycopg3/base.py", line 335, in _nodb_cursor
    yield cursor
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/tests/backends/postgresql/tests.py", line 111, in test_nodb_cursor_reraise_exceptions
    raise DatabaseError('exception')
django.db.utils.DatabaseError: exception

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/tests/backends/postgresql/tests.py", line 111, in test_nodb_cursor_reraise_exceptions
    raise DatabaseError('exception')
  File "/usr/lib/python3.8/contextlib.py", line 131, in __exit__
    self.gen.throw(type, value, traceback)
  File "/home/runner/.local/lib/python3.8/site-packages/django_psycopg3/base.py", line 337, in _nodb_cursor
    warnings.warn(
RuntimeWarning: Normally Django will use a connection to the 'postgres' database to avoid running initialization queries against the production database when it's not needed (for example, when running tests). Django was unable to create a connection to the 'postgres' database and will use the first PostgreSQL database instead.

https://github.com/django/django/commit/9ac3ef59

Also, update minimum Postgres version supported to 12 in sync with Django main branch / 4.2 release cycle changes.

Fixes error

======================================================================
ERROR: test_get_database_version (backends.postgresql.tests.Tests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/tests/backends/postgresql/tests.py", line 346, in test_get_database_version
    self.assertEqual(new_connection.get_database_version(), (11, 9))
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/db/backends/base/base.py", line 191, in get_database_version
    raise NotImplementedError(
NotImplementedError: subclasses of BaseDatabaseWrapper may require a get_database_version() method.

and failure

======================================================================
FAIL: test_check_database_version_supported (backends.postgresql.tests.Tests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/python3.8/unittest/mock.py", line 1325, in patched
    return func(*newargs, **newkeywargs)
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/tests/backends/postgresql/tests.py", line 352, in test_check_database_version_supported
    connection.check_database_version_supported()
  File "/usr/lib/python3.8/contextlib.py", line 120, in __exit__
    next(self.gen)
  File "/home/runner/work/django-psycopg3-backend/django-psycopg3-backend/django_repo/django/test/testcases.py", line 799, in _assert_raises_or_warns_cm
    yield cm
AssertionError: NotSupportedError not raised

when running Django test suite.

Works with /dvarrazzo/django/tree/psycopg3-4.1 well

Test improvement From: FAILED (failures=1, errors=14, skipped=763, expected failures=7) To: FAILED (errors=15, skipped=695, expected failures=7)