Can I Name a Primary Key in crateDB?

CrateDB
1

Hi

Can I Name a Primary Key in crateDB?

It doesn’t seem to follow the ANSI SQL standard of…

CREATE TABLE Persons (
    ID int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    CONSTRAINT PK_Person PRIMARY KEY (ID,LastName)
);

Regards

Mark

2

Hi @MarkF,

named primary keys are indeed not supported right now. There is an open feature request, you can upvote it to help with prioritizing: Support for named PRIMARY KEY constraints · Issue #11025 · crate/crate · GitHub

In your case, you can still define a composite primary key without naming it, like this:

CREATE TABLE Persons (
  ID int NOT NULL,
  LastName varchar(255) NOT NULL,
  FirstName varchar(255),
  Age int,
  PRIMARY KEY (ID, LastName)
);
3

OK - thanks for the quick response.

Mark

4

Hi @MarkF,
Just wanted to let you know that support for named PK constraints has now been implemented and you can try it out in our latest nightly builds.

5

Thanks for the update.

Regards

Mark