1. Mike Bayer Avatar Mike Bayer
  2. Untitled project
  3. sqlalchemy_old
  4. Issues

pg8000 fails to accept quoted_name as param type

Issue #4041 resolved
Mike Bayer repo owner created an issue 
#!

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)

  1. Mike Bayer reporter

    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>>

  2. Log in to comment
Assignee
–
Type
bug
Priority
major
Status
resolved
Component
postgres
Milestone
1.2
Votes
0
Watchers
1
Jira: the preferred issue tracker for Bitbucket. Join the team!