From a739a3449ff20ba90f92305ed4bbdd36e05bc862 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Fri, 19 Jul 2019 10:40:27 -0400 Subject: Include 'p' for get_indexes() query Added support for reflection of indexes on PostgreSQL partitioned tables, which was added to PostgreSQL as of version 11. Fixes: #4771 Change-Id: I9e8e75c4d8a667b4d52d12afbd384e0a8db00466 --- lib/sqlalchemy/dialects/postgresql/base.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/sqlalchemy') diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index 5aea02cfc..8fbd97ebe 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -3255,7 +3255,7 @@ class PGDialect(default.DefaultDialect): pg_am am on i.relam = am.oid WHERE - t.relkind IN ('r', 'v', 'f', 'm') + t.relkind IN ('r', 'v', 'f', 'm', 'p') and t.oid = :table_oid and ix.indisprimary = 'f' ORDER BY -- cgit v1.2.1