Re: Primary key is set to the foreign key value

Adam Allgaier wrote:
> Change the table definition to this:
> 
>   <table name="Person_SSN" description="Person SSN" idMethod="none">
> 
> You are generating the PK value yourself, so you don't need Torque or Postgres to do it for you.

Right. The Torque idbroker is made for numerical primary keys. Your
primary key is CHAR. Are you sure you want to do this?

>   <table name="Person_SSN" description="Person SSN">
[...]
>     <column name="SSN"
>       required="true"
>       primaryKey="true" 
>       type="CHAR" size="9"
              ^^^^
>       description="SSN"/>

Bye, Thomas.