Skip to content

BUG: specifying multiple columns as primary keys broken in io.sql.get_schema #10385

Closed
@jorisvandenbossche

Description

@jorisvandenbossche

See http://stackoverflow.com/questions/30911299/get-schema-multiple-primary-keys

I think this still works for the fallback sqlite version, but not for the new sqlalchemy implementation. in PrimaryKeyConstraint, the columns should be feeded as separate positional arguments instead of a list (https://github.com/pydata/pandas/blob/master/pandas/io/sql.py#L837). So just needs an unacking *.

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugIO SQLto_sql, read_sql, read_sql_query

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions