I'm trying to make a small table that has a compound PK that includes an identity field like this
CREATE TABLE agreement4 ( agreementid identity NOT NULL, agreementtypeid int4 NOT NULL, version VARCHAR(6) NOT NULL, companyid int4 NOT NULL, userid int4 NOT NULL, date TIMESTAMP NOT NULL, CONSTRAINT PK_AGREEMENT4 PRIMARY KEY (agreementid, agreementtypeid, version)) This fails with a duplicate primary key exception. Changing agreement id to int4 makes the table creation succeed. Any help would be greatly appreciated. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/H4zEzI9p230J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
