Thank you for the pointers. I was expecting that if there is no primary key 
but only one unique key, the generator would pick it by default. If there 
are multiple unique keys, I understand that one cannot pick at random. 
Anyways, I tried specifying via configuration and still didn't see DAO 
being generated. Perhaps, missing something basic on my end. Here's what my 
table definition looks like in the Postgres database.

CREATE TABLE public."PersonEmail"
(
  "personId" character(8) NOT NULL,
  email character varying(64) NOT NULL,
  "contactTypeId" smallint NOT NULL,
  CONSTRAINT "PersonEmail_personId_contactTypeId_key" UNIQUE ("personId", 
"contactTypeId")
)

And here are the two configurations that I tried independently.

<syntheticPrimaryKeys>public\.PersonEmail\.COLUMN(1|3)</syntheticPrimaryKeys>

<overridePrimaryKeys>PersonEmail_personId_contactTypeId_key</overridePrimaryKeys>

Appreciate if you could point me to what's wrong in the above 
configurations? I also presume, I can have multiple entries, each delimited 
by "|".  

-- 
You received this message because you are subscribed to the Google Groups "jOOQ 
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to