Hi,

What is the proper way to setup auto PK generation when Cayenne 4 +
PostgreSQL are in use?

Suppose I have a simple table like this.

create table "asset" (
  "asset_id" bigserial not null
  , "name" character varying not null
  , constraint "asset_PKC" primary key ("asset_id")
) ;

No matter how I configure the PK generation settings, it seems Cayenne
runtime
requires sequence named "pk_asset".

Ideally we would like to automate the table-sequence combination by using
serial/bigserial.

How can I tell Cayenne stop requiring "pk_asset"?


thank you,
nobu

Reply via email to