BUG: specifying multiple columns as primary keys broken in io.sql.get_schema (original) (raw)

Skip to content

Navigation Menu

Sign in

Appearance settings

• • AI CODE CREATION
    * GitHub CopilotWrite better code with AI
    * GitHub SparkBuild and deploy intelligent apps
    * GitHub ModelsManage and compare prompts
    * MCP RegistryNewIntegrate external tools
  • DEVELOPER WORKFLOWS
    * ActionsAutomate any workflow
    * CodespacesInstant dev environments
    * IssuesPlan and track work
    * Code ReviewManage code changes
  • APPLICATION SECURITY
    * GitHub Advanced SecurityFind and fix vulnerabilities
    * Code securitySecure your code as you build
    * Secret protectionStop leaks before they start
  • EXPLORE
    * Why GitHub
    * Documentation
    * Blog
    * Changelog
    * Marketplace

View all features

• • BY COMPANY SIZE
    * Enterprises
    * Small and medium teams
    * Startups
    * Nonprofits
  • BY USE CASE
    * App Modernization
    * DevSecOps
    * DevOps
    * CI/CD
    * View all use cases
  • BY INDUSTRY
    * Healthcare
    * Financial services
    * Manufacturing
    * Government
    * View all industries

View all solutions

• • EXPLORE BY TOPIC
    * AI
    * Software Development
    * DevOps
    * Security
    * View all topics
  • EXPLORE BY TYPE
    * Customer stories
    * Events & webinars
    * Ebooks & reports
    * Business insights
    * GitHub Skills
  • SUPPORT & SERVICES
    * Documentation
    * Customer support
    * Community forum
    * Trust center
    * Partners
• • COMMUNITY
    * GitHub SponsorsFund open source developers
  • PROGRAMS
    * Security Lab
    * Maintainer Community
    * Accelerator
    * Archive Program
  • REPOSITORIES
    * Topics
    * Trending
    * Collections
• • ENTERPRISE SOLUTIONS
    * Enterprise platformAI-powered developer platform
  • AVAILABLE ADD-ONS
    * GitHub Advanced SecurityEnterprise-grade security features
    * Copilot for BusinessEnterprise-grade AI features
    * Premium SupportEnterprise-grade 24/7 support
• Pricing

Provide feedback

We read every piece of feedback, and take your input very seriously.

Include my email address so I can be contacted

Saved searches

Use saved searches to filter your results more quickly

Sign in

Sign up

Appearance settings

pandas-dev / pandas Public

• Notifications You must be signed in to change notification settings

• Fork19.4k

• Star 47.3k

• Code

• Issues 3.4k

• Pull requests 164

• Actions

• Projects

• Security

• Insights

Additional navigation options

New issue

New issue

Closed

Closed

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

#10385

Labels

BugIO SQLto_sql, read_sql, read_sql_query

Milestone

0.17.0

Description

jorisvandenbossche

opened

on Jun 18, 2015

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

• 0.17.0

Relationships

None yet

Development

No branches or pull requests

Issue actions