From d84e3eb2842a23c39836d356479e05820a2b7808 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sat, 16 Jun 2012 17:54:07 -0400 Subject: [PATCH] - [bug] removed unnecessary table clause when reflecting enums, [ticket:2510]. --- CHANGES | 5 +++++ lib/sqlalchemy/dialects/postgresql/base.py | 1 - 2 files changed, 5 insertions(+), 1 deletion(-) diff --git a/CHANGES b/CHANGES index 48fad18932..63d8c1162d 100644 --- a/CHANGES +++ b/CHANGES @@ -64,6 +64,11 @@ CHANGES being present on Py3K string. [ticket:2503]. +- postgresql + - [bug] removed unnecessary table clause when + reflecting enums, [ticket:2510]. Courtesy + Gunnlaugur Þór Briem. + - oracle - [bug] Added ROWID to oracle.*, [ticket:2483] diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index e4bcfa2ede..0ff54f8a2c 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -1622,7 +1622,6 @@ class PGDialect(default.DefaultDialect): e.enumlabel as "label" FROM pg_catalog.pg_type t LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace - LEFT JOIN pg_catalog.pg_constraint r ON t.oid = r.contypid LEFT JOIN pg_catalog.pg_enum e ON t.oid = e.enumtypid WHERE t.typtype = 'e' ORDER BY "name", e.oid -- e.oid gives us label order -- 2.47.2