summaryrefslogtreecommitdiff
path: root/django/db/backends/postgresql/introspection.py
AgeCommit message (Collapse)Author
2026-01-18Applied Black's 2026 stable style.Mariusz Felisiak
https://github.com/psf/black/releases/tag/26.1.0
2025-11-17Fixed #24920 -- Added support for DecimalField with no precision.Mariusz Felisiak
Thanks Lily for the review.
2025-11-14Refs #24928 -- Added introspection support for PostgreSQL HStoreField.Mariusz Felisiak
2025-10-31Fixed #36661 -- Added introspection of database-level delete options.Mariusz Felisiak
2025-09-29Skipped NOT NULL constraints on PostgreSQL 18+.Mariusz Felisiak
Thanks Simon Charette for the implementation idea.
2025-07-23Refs #36500 -- Rewrapped long docstrings and block comments via a script.django-bot
Rewrapped long docstrings and block comments to 79 characters + newline using script from https://github.com/medmunds/autofix-w505.
2025-03-31Refs #28909 -- Simplified code using unpacking generalizations.Aarni Koskela
2023-01-12Refs #18468 -- Used obj_description() with a catalog name on PostgreSQL.Mariusz Felisiak
obj_description(object oid) without a catalog name is deprecated since there is no guarantee that OIDs are unique across different system catalogs. Thanks Tim Graham for the report.
2022-12-28Fixed #18468 -- Added support for comments on columns and tables.kimsoungryoul
Thanks Jared Chung, Tom Carrick, David Smith, Nick Pope, and Mariusz Felisiak for reviews. Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com> Co-authored-by: Nick Pope <nick@nickpope.me.uk>
2022-12-08Made inspectdb used Cursor.description.display_size for CharFields' max_length.Mariusz Felisiak
internal_size is size for fixed-size types not for char types.
2022-04-13Fixed #30511 -- Used identity columns instead of serials on PostgreSQL.Florian Apolloner
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
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-01-19Fixed #32357 -- Dropped support for PostgreSQL 9.6 and PostGIS 2.3.Mariusz Felisiak
2020-09-21Fixed #31777 -- Added support for database collations to Char/TextFields.Tom Carrick
Thanks Simon Charette and Mariusz Felisiak for reviews.
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-05-08Fixed #12990, Refs #27694 -- Added JSONField model field.sage
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>
2020-02-04Simplified imports from django.db and django.contrib.gis.db.Nick Pope
2019-08-02Fixed #30661 -- Added models.SmallAutoField.Nick Pope
2019-07-22Fixed #30644 -- Made introspection use pg_table_is_visible() instead of ↵Georgi Yanchev
filtering by public schema on PostgreSQL.
2019-07-20Simplified get_key_columns()/get_relations() introspection methods for ↵Mariusz Felisiak
PostgreSQL.
2019-04-05Fixed #30331 -- Added support for psycopg2 2.8.Mariusz Felisiak
2018-11-19Refs #29722 -- Added introspection of partitions for PostgreSQL.Nick Pope
2018-10-21Fixed #29870 -- Added DurationField introspection for Oracle and PostgreSQL.Mariusz Felisiak
Thanks Tim Graham for the review.
2018-10-02Refs #29722 -- Added introspection of materialized views for PostgreSQL.Nick Pope
2018-10-02Fixed #29719 -- Added introspection of foreign tables for PostgreSQL.Nick Pope
Thanks infinite-l00p for the initial patch.
2018-09-14Simplified introspection methods for PostgreSQL.Nick Pope
2018-08-02Fixed #29614 -- Added BTreeIndex to django.contrib.postres.Nick Pope
2018-05-26Refs #27098 -- Removed unused introspection queries.Markus Holtermann
Unused since 578711c31052625cc87319cf1c46662c14d75ce9. Thanks Ian Foote for finding this.
2017-12-21Refs #28909 -- Simplifed code using unpacking generalizations.Nick Pope
2017-09-27Fixed #28626 -- Dropped support for PostgreSQL 9.3.Tim Graham
Thanks Simon Charette for the introspection changes.
2017-09-22Refs #27098 -- Removed DatabaseIntrospection.get_indexes() per deprecation ↵Tim Graham
timeline.
2017-09-13Refs #27090 -- Added real database sequence introspection.Mariusz Felisiak
Thanks Mariusz Felisiak for the Oracle part and Tim Graham for the review.
2017-05-15Fixed #28197 -- Fixed introspection of index field ordering on PostgreSQL.Tim Schneider
2017-03-04Refs #27795 -- Removed unneeded force_text callsClaude Paroz
Thanks Tim Graham for the review.
2017-02-28Refs #27656 -- Updated django.db docstring verbs according to PEP 257.Anton Samarchyan
2017-02-15Fixed #27135 -- Made index introspection return Index.suffix.Tim Graham
2017-01-25Refs #23919 -- Replaced super(ClassName, self) with super().chillaranand
2017-01-18Refs #23919 -- Removed encoding preambles and future importsClaude Paroz
2017-01-15Fixed #25809 -- Added BrinIndex support in django.contrib.postgres.Mads Jensen
Thanks Tim Graham and Markus Holtermann for review.
2016-11-30Refs #24245 -- Added introspection for database defaults on Oracle.Mariusz Felisiak
2016-10-17Refs #20888 -- Fixed index ordering introspection on PostgreSQL 9.6.François Freitag
2016-09-12Refs #27098 -- Added introspection for expression-based index on PostgreSQLClaude Paroz
Also test it on PostGIS raster fields.
2016-09-12Reformatted PostgreSQL query for better readabilityClaude Paroz
2016-09-12Fixed #27098 -- Deprecated DatabaseIntrospection.get_indexesClaude Paroz
Thanks Akshesh <aksheshdoshi@gmail.com> for help with the PostgreSQL query. Thanks Tim Graham for the review.
2016-09-02Fixed #25476 -- Allowed PostgreSQL introspection to work regardless of table ↵Marcos Vives Del Sol
owner.
2016-08-30Removed double semicolon in SQL queryClaude Paroz
2016-08-30Refs #27097, #27098 -- Moved PostgreSQL index type introspection to ↵Akshesh
get_constraints().