- changed status to resolved
pg8000 fails to accept quoted_name as param type
Issue #4041
resolved
#!
NotSupportedError: (pg8000.core.NotSupportedError) type <class 'sqlalchemy.sql.elements.quoted_name'>not mapped to pg type [SQL: u"SELECT c.relname FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname = %s AND c.relkind = 'r'"] [parameters: ('test_schema',)]
Comments (1)
-
reporter - Log in to comment
Add quoted_name to pg8000 py_types
Fixed bug where the pg8000 driver would fail if using :meth:
.MetaData.reflect
with a schema name, since the schema name would be sent as a "quoted_name" object that's a string subclass, which pg8000 doesn't recognize. The quoted_name type is added to pg8000's py_types collection on connect.Change-Id: Id0f838320cb66563685e094e4eae2d5116100d27 Fixes:
#4041→ <<cset 03560c4b8330>>