From 45ef3df7d07489ee0b76479cc799faa92e443a69 Mon Sep 17 00:00:00 2001 From: Nick Pope Date: Wed, 12 Sep 2018 01:36:15 +0100 Subject: Fixed #29719 -- Added introspection of foreign tables for PostgreSQL. Thanks infinite-l00p for the initial patch. --- django/db/backends/postgresql/introspection.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'django') diff --git a/django/db/backends/postgresql/introspection.py b/django/db/backends/postgresql/introspection.py index afd035df77..c20d7b659e 100644 --- a/django/db/backends/postgresql/introspection.py +++ b/django/db/backends/postgresql/introspection.py @@ -44,11 +44,11 @@ class DatabaseIntrospection(BaseDatabaseIntrospection): SELECT c.relname, c.relkind FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace - WHERE c.relkind IN ('r', 'v') + WHERE c.relkind IN ('f', 'r', 'v') AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid) """) - mapping = {'r': 't', 'v': 'v'} + mapping = {'f': 't', 'r': 't', 'v': 'v'} return [ TableInfo(row[0], mapping[row[1]]) for row in cursor.fetchall() if row[0] not in self.ignored_tables -- cgit v1.3