8000 pandas extension `pg_copy_from` silently converts `text` objects to `str` · Issue #25 · dssg/ohio · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
pandas extension pg_copy_from silently converts text objects to str #25
Open
@not-the-fish

Description

@not-the-fish

As a user, I expect, because I am also passing a sqlalchemy connectable, that pg_copy_from would respect the properties of a text object passed as the query (including using the default values of any bound parameters at execution), but it silently converts the text object to a plain str.

A couple of solutions are possible:

  1. Document that the copy extensions convert things to string (and maybe give a warning when getting something other than a string)
  2. Support text objects in a way compatible with user expectations of sqlalchemy

2 seems nicer but 🤷

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      0