mustafasrepo commented on PR #7160: URL: https://github.com/apache/arrow-datafusion/pull/7160#issuecomment-1659667273
> Perhaps we should consider scenarios where primary keys are defined multiple times. > > For example: > > ```shell > psql=> create table foo( > a int primary key, > b int, > c int, > primary key(b,c) > ); > > ERROR: multiple primary keys for table "foo" are not allowed > LINE 5: primary key(b,c) > ``` > > It will fail in PostgreSQL. I think we may choose not to fail, for these cases as long as both `a` and `(b, c)` satisfies primary key constraint (which is the responsibility of the user). -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
