summaryrefslogtreecommitdiff
path: root/django/db/backends/postgresql
Commit message (Collapse)AuthorAgeFilesLines
...
* Refs #32355 -- Bumped required psycopg2 version to 2.8.4.Mariusz Felisiak2021-12-221-2/+2
| | | psycopg2 2.8.4 is the first release to support Python 3.8.
* Fixed #33279 -- Fixed handling time zones with "-" sign in names.Can Sarigol2021-11-121-4/+5
| | | | | | Thanks yakimka for the report. Regression in fde9b7d35e4e185903cc14aa587ca870037941b1.
* Removed DatabaseIntrospection.get_key_columns().Mariusz Felisiak2021-11-101-4/+1
| | | Thanks Simon Charette for the report.
* Fixed DatabaseIntrospection.get_relations() docstring.Tim Graham2021-11-101-1/+1
| | | The foreign keys are "in" the given table, not "to" it.
* Fixed #33228 -- Changed value of ↵Chinmoy2021-10-281-1/+0
| | | | BaseDatabaseFeatures.has_case_insensitive_like to False.
* Refs #32943 -- Added support for covering SP-GiST indexes on PostgreSQL 14+.Nick Pope2021-10-011-0/+1
|
* Fixed #32961 -- Added BitXor() aggregate to django.contrib.postgres.Nick Pope2021-10-011-0/+5
|
* Fixed #33160 -- Avoided suppressing query errors in _nodb_cursor() on ↵Daniel Hahler2021-10-011-0/+3
| | | | PostgreSQL.
* Refs #10929 -- Allowed NowUTC SQL customization for third-party backends.Tim Graham2021-08-241-0/+1
|
* Refs #32508 -- Raised ImproperlyConfigured/TypeError instead of using "assert".Mateo Radman2021-07-051-3/+6
|
* Fixed #32687 -- Restored passing process’ environment to underlying tool ↵Konstantin Alekseev2021-04-271-1/+1
| | | | | | in dbshell on PostgreSQL. Regression in bbe6fbb8768e8fb1aecb96d51c049d7ceaf802d3.
* Fixed #32456 -- Added dbshell support for specifying a password file on ↵Hasan Ramezani2021-03-011-0/+3
| | | | PostgreSQL.
* Refs #32292 -- Made dbshell do not use 'postgres' database when service name ↵Mariusz Felisiak2021-02-261-2/+6
| | | | | is set. Regression in dcb3ad3319cad5c270a1856fd5f355e37cf9d474.
* Fixed #32355 -- Dropped support for Python 3.6 and 3.7Mariusz Felisiak2021-02-101-6/+1
|
* Fixed #32403 -- Fixed re-raising DatabaseErrors when using only 'postgres' ↵Mariusz Felisiak2021-02-021-0/+3
| | | | | | | database. Thanks Kazantcev Andrey for the report. Regression in f48f671223a20b161ca819cf7d6298e43b8ba5fe.
* Fixed #32292 -- Added support for connection by service name to PostgreSQL.Hasan Ramezani2021-01-202-6/+22
|
* Fixed #32357 -- Dropped support for PostgreSQL 9.6 and PostGIS 2.3.Mariusz Felisiak2021-01-192-19/+6
|
* Refs #31369 -- Removed models.NullBooleanField per deprecation timeline.Mariusz Felisiak2021-01-141-1/+0
|
* Refs #26167 -- Changed default value of ↵Hannes Ljungberg2021-01-141-1/+0
| | | | DatabaseFeatures.supports_expression_indexes to True.
* Fixed #26167 -- Added support for functional indexes.Hannes Ljungberg2021-01-132-1/+3
| | | | | | Thanks Simon Charette, Mads Jensen, and Mariusz Felisiak for reviews. Co-authored-by: Markus Holtermann <info@markusholtermann.eu>
* Refs #26167 -- Made DatabaseSchemaEditor._create_index_sql()'s fields ↵Hannes Ljungberg2020-12-231-6/+16
| | | | argument optional and kwarg-only.
* Fixed #32178 -- Allowed database backends to skip tests and mark expected ↵Hasan Ramezani2020-12-101-0/+6
| | | | | failures. Co-authored-by: Tim Graham <timograham@gmail.com>
* Fixed #32201 -- Removed obsolete isort:skip's.Seamus Quinn2020-11-191-6/+6
| | | Obsolete as of isort 5.
* Refs #32061 -- Unified DatabaseClient.runshell() in db backends.Simon Charette2020-10-291-24/+23
|
* Fixed #32046 -- Added CreateCollation/RemoveCollation operations for PostgreSQL.Tom Carrick2020-10-211-0/+1
|
* Fixed #31640 -- Made Trunc() truncate datetimes to Date/TimeField in a ↵David-Wobrock2020-10-141-3/+5
| | | | specific timezone.
* Fixed #32073 -- Skipped collation tests on PostgreSQL < 10.Mariusz Felisiak2020-10-061-4/+10
| | | | | PostgreSQL < 10 doesn't support ICU collations. Thanks Hannes Ljungberg for the report.
* Fixed #31777 -- Added support for database collations to Char/TextFields.Tom Carrick2020-09-212-1/+5
| | | | Thanks Simon Charette and Mariusz Felisiak for reviews.
* Refs #21181 -- Corrected DatabaseFeatures.test_collations for Swedish collation.Tom Carrick2020-09-181-1/+1
| | | | Previously, backends used different keys "swedish-ci" or "swedish_ci".
* Added DatabaseIntrospection.index_default_access_method hook on the ↵Tim Graham2020-09-151-3/+10
| | | | | PostgreSQL backend. This hook is for the CockroachDB backend where the name is 'prefix'.
* Fixed #31956 -- Fixed crash of ordering by JSONField with a custom decoder ↵Mariusz Felisiak2020-08-282-4/+4
| | | | | | | on PostgreSQL. Thanks Marc Debureaux for the report. Thanks Simon Charette, Nick Pope, and Adam Johnson for reviews.
* Fixed #24533 -- Dropped PostgreSQL sequence and Oracle identity when ↵Tim Graham2020-08-241-0/+13
| | | | migrating away from AutoField.
* Fixed #21181 -- Added Collate database function.Tom Carrick2020-08-111-0/+3
| | | | Thanks Simon Charette for reviews.
* Refs #31829 -- Added ↵Tim Graham2020-07-301-0/+1
| | | | | DatabaseFeatures.json_key_contains_list_matching_requires_list. CockroachDB's behavior matches PostgreSQL.
* Refs #27996 -- Doc'd no extension required for RandomUUID() on PostgreSQL 13+.Nick Pope2020-07-281-0/+4
| | | | | https://www.postgresql.org/docs/13/functions-uuid.html https://www.postgresql.org/docs/13/pgcrypto.html#id-1.11.7.34.10.5
* Fixed #31815 -- Fixed schema value encoding on PostgreSQL.Mariusz Felisiak2020-07-271-1/+4
|
* Fixed #31731 -- Removed unreachable code for resetting sequences of ↵Ravindar Sharma2020-07-171-15/+0
| | | | | | | | | | | | | | | auto-created m2m tables in sequence_reset_sql(). Unreachable because f.remote_field.through is truthy for all m2m fields. Resetting sequences of auto-created m2m tables in sequence_reset_sql() is also unnecessary: - in sqlsequencereset since c39ec6dccb389fbb4047e44f5247e18bb76ae598 because auto-created tables are included in model_list, - in loaddata because there is no it need to reset sequences for models not loaded directly. - in create_default_site() because it doesn't have m2m fields.
* Stopped adapting DecimalField values to strings on PostgreSQL.Simon Charette2020-07-141-0/+3
| | | | The psycopg2 backend uses the type information to provide type hints.
* Fixed #31735 -- Fixed migrations crash on namespaced inline FK addition on ↵Simon Charette2020-06-241-1/+1
| | | | | | | | | | | PostgreSQL. The namespace of the constraint must be included when making the constraint immediate. Regression in 22ce5d0031bd795ade081394043833e82046016c. Thanks Rodrigo Estevao for the report.
* Fixed #30913 -- Added support for covering indexes on PostgreSQL 11+.Hannes Ljungberg2020-06-042-3/+10
|
* Fixed #31630 -- Replaced introspection features with ↵Hasan Ramezani2020-06-041-3/+9
| | | | DatabaseFeatures.introspected_field_types.
* Fixed #30375 -- Added FOR NO KEY UPDATE support to ↵Manuel Weitzman2020-05-211-0/+1
| | | | QuerySet.select_for_update() on PostgreSQL.
* Refs #12990 -- Added DatabaseFeatures.has_json_operators.Tim Graham2020-05-181-0/+1
| | | CockroachDB also has them.
* Fixed #31579 -- Dropped support for PostgreSQL 9.5 and PostGIS 2.2.Mariusz Felisiak2020-05-141-6/+0
|
* Fixed #12990, Refs #27694 -- Added JSONField model field.sage2020-05-084-0/+6
| | | | | | | | | | | Thanks to Adam Johnson, Carlton Gibson, Mariusz Felisiak, and Raphael Michel for mentoring this Google Summer of Code 2019 project and everyone else who helped with the patch. Special thanks to Mads Jensen, Nick Pope, and Simon Charette for extensive reviews. Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com>
* Fixed #20581 -- Added support for deferrable unique constraints.Ian Foote2020-04-301-0/+1
|
* Fixed #31473 -- Made sql_flush() use RESTART IDENTITY to reset sequences on ↵Jon Dufresne2020-04-171-16/+9
| | | | | | | | | | | | PostgreSQL. The sql_flush() positional argument sequences is replaced by the boolean keyword-only argument reset_sequences. This ensures that the old function signature can't be used by mistake when upgrading Django. When the new argument is True, the sequences of the truncated tables will reset. Using a single boolean value, rather than a list, allows making a binary yes/no choice as to whether to reset all sequences rather than a working on a completely different set.
* Simplified DatabaseOperations.sql_flush() on Oracle and PostgreSQL.Jon Dufresne2020-04-171-20/+20
| | | | Added early return to decrease an indentation level.
* Fixed #29501 -- Allowed dbshell to pass options to underlying tool.Adam Johnson2020-04-141-3/+4
|
* Fixed #31233 -- Closed database connections and cursors after use.Jon Dufresne2020-02-061-3/+5
|