summaryrefslogtreecommitdiff
path: root/django/db/backends/postgresql
AgeCommit message (Collapse)Author
2023-02-01[4.1.x] Refs #33476 -- Applied Black's 2023 stable style.David Smith
Black 23.1.0 is released which, as the first release of the year, introduces the 2023 stable style. This incorporates most of last year's preview style. https://github.com/psf/black/releases/tag/23.1.0 Backport of 097e3a70c1481ee7b042b2edd91b2be86fb7b5b6 from main.
2022-10-01[4.1.x] Refs #34058 -- Fixed changing/deleting sequences when altering ↵Mariusz Felisiak
pre-Django 4.1 auto fields on PostgreSQL. Thanks Anders Kaseorg for the report. Follow up to 19e6efa50b603af325e7f62058364f278596758f. Regression in 2eea361eff58dd98c409c5227064b901f41bd0d6. Backport of bc3b8f152452ba0e41f28baa93c0bf8f39cddb09 from main
2022-09-29[4.1.x] Fixed #34058 -- Changed sequence types when altering pre-Django 4.1 ↵Mariusz Felisiak
auto fields on PostgreSQL. Thanks Anders Kaseorg for the report. Thanks Florian Apolloner for pair programming. Regression in 2eea361eff58dd98c409c5227064b901f41bd0d6. Backport of 19e6efa50b603af325e7f62058364f278596758f from main
2022-08-17[4.1.x] Fixed #33932 -- Fixed altering AutoFields to OneToOneField on ↵Benoît Vinot
PostgreSQL. Regression in 2eea361eff58dd98c409c5227064b901f41bd0d6. Backport of e3cb8bcb7d2a2d392e726ee1f7e32a8d9038e14c from main
2022-07-06[4.1.x] Refs CVE-2022-34265 -- Properly escaped Extract() and Trunc() ↵Simon Charette
parameters. Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com> Backport of 877c800f255ccaa7abde1fb944de45d1616f5cc9 from main
2022-05-12Refs #27064 -- Added RenameIndex migration operation.David Wobrock
2022-05-04Fixed #25105 -- Checked deferred constraints before updating rows on PostgreSQL.David Wobrock
2022-05-04Fixed #33675 -- Dropped support for PostgreSQL 10 and PostGIS 2.4.Mariusz Felisiak
2022-04-14Removed unneeded code in explain_query_prefix()Tim Graham
2022-04-13Fixed #30511 -- Used identity columns instead of serials on PostgreSQL.Florian Apolloner
2022-04-11Fixed CVE-2022-28347 -- Protected QuerySet.explain(**options) against SQL ↵Mariusz Felisiak
injection on PostgreSQL.
2022-02-22Refs #33517 -- Prevented __second lookup from returning fractional seconds ↵nabil-rady
on PostgreSQL.
2022-02-18Fixed #33379 -- Added minimum database version checks.Hasan Ramezani
Thanks Tim Graham for the review.
2022-02-07Refs #33476 -- Refactored code to strictly match 88 characters line length.Mariusz Felisiak
2022-02-07Refs #33476 -- Reformatted code with Black.django-bot
2022-01-19Fixed #31685 -- Added support for updating conflicts to QuerySet.bulk_create().sean_c_hsu
Thanks Florian Apolloner, Chris Jerdonek, Hannes Ljungberg, Nick Pope, and Mariusz Felisiak for reviews.
2021-12-22Refs #32355 -- Bumped required psycopg2 version to 2.8.4.Mariusz Felisiak
psycopg2 2.8.4 is the first release to support Python 3.8.
2021-11-12Fixed #33279 -- Fixed handling time zones with "-" sign in names.Can Sarigol
Thanks yakimka for the report. Regression in fde9b7d35e4e185903cc14aa587ca870037941b1.
2021-11-10Removed DatabaseIntrospection.get_key_columns().Mariusz Felisiak
Thanks Simon Charette for the report.
2021-11-10Fixed DatabaseIntrospection.get_relations() docstring.Tim Graham
The foreign keys are "in" the given table, not "to" it.
2021-10-28Fixed #33228 -- Changed value of ↵Chinmoy
BaseDatabaseFeatures.has_case_insensitive_like to False.
2021-10-01Refs #32943 -- Added support for covering SP-GiST indexes on PostgreSQL 14+.Nick Pope
2021-10-01Fixed #32961 -- Added BitXor() aggregate to django.contrib.postgres.Nick Pope
2021-10-01Fixed #33160 -- Avoided suppressing query errors in _nodb_cursor() on ↵Daniel Hahler
PostgreSQL.
2021-08-24Refs #10929 -- Allowed NowUTC SQL customization for third-party backends.Tim Graham
2021-07-05Refs #32508 -- Raised ImproperlyConfigured/TypeError instead of using "assert".Mateo Radman
2021-04-27Fixed #32687 -- Restored passing process’ environment to underlying tool ↵Konstantin Alekseev
in dbshell on PostgreSQL. Regression in bbe6fbb8768e8fb1aecb96d51c049d7ceaf802d3.
2021-03-01Fixed #32456 -- Added dbshell support for specifying a password file on ↵Hasan Ramezani
PostgreSQL.
2021-02-26Refs #32292 -- Made dbshell do not use 'postgres' database when service name ↵Mariusz Felisiak
is set. Regression in dcb3ad3319cad5c270a1856fd5f355e37cf9d474.
2021-02-10Fixed #32355 -- Dropped support for Python 3.6 and 3.7Mariusz Felisiak
2021-02-02Fixed #32403 -- Fixed re-raising DatabaseErrors when using only 'postgres' ↵Mariusz Felisiak
database. Thanks Kazantcev Andrey for the report. Regression in f48f671223a20b161ca819cf7d6298e43b8ba5fe.
2021-01-20Fixed #32292 -- Added support for connection by service name to PostgreSQL.Hasan Ramezani
2021-01-19Fixed #32357 -- Dropped support for PostgreSQL 9.6 and PostGIS 2.3.Mariusz Felisiak
2021-01-14Refs #31369 -- Removed models.NullBooleanField per deprecation timeline.Mariusz Felisiak
2021-01-14Refs #26167 -- Changed default value of ↵Hannes Ljungberg
DatabaseFeatures.supports_expression_indexes to True.
2021-01-13Fixed #26167 -- Added support for functional indexes.Hannes Ljungberg
Thanks Simon Charette, Mads Jensen, and Mariusz Felisiak for reviews. Co-authored-by: Markus Holtermann <info@markusholtermann.eu>
2020-12-23Refs #26167 -- Made DatabaseSchemaEditor._create_index_sql()'s fields ↵Hannes Ljungberg
argument optional and kwarg-only.
2020-12-10Fixed #32178 -- Allowed database backends to skip tests and mark expected ↵Hasan Ramezani
failures. Co-authored-by: Tim Graham <timograham@gmail.com>
2020-11-19Fixed #32201 -- Removed obsolete isort:skip's.Seamus Quinn
Obsolete as of isort 5.
2020-10-29Refs #32061 -- Unified DatabaseClient.runshell() in db backends.Simon Charette
2020-10-21Fixed #32046 -- Added CreateCollation/RemoveCollation operations for PostgreSQL.Tom Carrick
2020-10-14Fixed #31640 -- Made Trunc() truncate datetimes to Date/TimeField in a ↵David-Wobrock
specific timezone.
2020-10-06Fixed #32073 -- Skipped collation tests on PostgreSQL < 10.Mariusz Felisiak
PostgreSQL < 10 doesn't support ICU collations. Thanks Hannes Ljungberg for the report.
2020-09-21Fixed #31777 -- Added support for database collations to Char/TextFields.Tom Carrick
Thanks Simon Charette and Mariusz Felisiak for reviews.
2020-09-18Refs #21181 -- Corrected DatabaseFeatures.test_collations for Swedish collation.Tom Carrick
Previously, backends used different keys "swedish-ci" or "swedish_ci".
2020-09-15Added DatabaseIntrospection.index_default_access_method hook on the ↵Tim Graham
PostgreSQL backend. This hook is for the CockroachDB backend where the name is 'prefix'.
2020-08-28Fixed #31956 -- Fixed crash of ordering by JSONField with a custom decoder ↵Mariusz Felisiak
on PostgreSQL. Thanks Marc Debureaux for the report. Thanks Simon Charette, Nick Pope, and Adam Johnson for reviews.
2020-08-24Fixed #24533 -- Dropped PostgreSQL sequence and Oracle identity when ↵Tim Graham
migrating away from AutoField.
2020-08-11Fixed #21181 -- Added Collate database function.Tom Carrick
Thanks Simon Charette for reviews.
2020-07-30Refs #31829 -- Added ↵Tim Graham
DatabaseFeatures.json_key_contains_list_matching_requires_list. CockroachDB's behavior matches PostgreSQL.