dbpatterns icon indicating copy to clipboard operation
dbpatterns copied to clipboard

Multiple component primary keys are exported wrong

Open francois opened this issue 12 years ago • 1 comments

Create a table, add two fields, mark both as PRIMARY KEY. Export as Postgres. This is what's generated:

CREATE TABLE a(
  f1 int PRIMARY KEY,
  f2 int PRIMARY KEY
);

This is what's desired:

CREATE TABLE a(
  f1 int,
  f2 int,
  PRIMARY KEY(f1, f2)
);

francois avatar Nov 26 '12 20:11 francois