Re: autoIncrement in PostgreSQL

[Scott Eade]

Thomas Lohmueller wrote:

I have a problem with autoIncrement in PostgreSQL. The following part from the 
xml-file does not even generate valid SQL. 

   <table name="addr_groups">
       <column name="addr_group_id" type="BIGINT" autoIncrement="true" 
required="true" primaryKey="true" />
       <column name="name" type="VARCHAR" size="20" required="true" />
       <column name="descr" type="VARCHAR" size="100" required="true" 
default="" />
   </table>

Torque-gen-3.1 generates this sql-code. 
CREATE TABLE addr_groups
(
                                   addr_group_id,
                                   name varchar (20) NOT NULL,
                                   descr varchar (100) default '' NOT NULL,
   PRIMARY KEY (addr_group_id)
);

The database-tag contains defaultIdMethod?="native".

Do you also specify a name attribute on your database element?  Have you 
tried using an idMethod attribute on your table element?

For PostgreSQL I recommend that you specify include:

   <id-method-parameter name="seqName" 
value="addr_groups_addr_group_id_seq"/>

within your table element.

You should also be sure to check out:

http://nagoya.apache.org/wiki/apachewiki.cgi?TorqueProjectPages/PostgreSQLFAQ

Scott
--
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]