Return-Path: 
 <torque-user-return-3879-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 87042 invoked from network); 4 Jan 2004 23:55:40 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 4 Jan 2004 23:55:40 -0000
Received: (qmail 44420 invoked by uid 500); 4 Jan 2004 23:55:24 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 44214 invoked by uid 500); 4 Jan 2004 23:55:23 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Subscribe: <mailto:torque-user-subscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 44194 invoked from network); 4 Jan 2004 23:55:22 -0000
Received: from unknown (HELO mail.iinet.net.au) (203.59.3.40)
  by daedalus.apache.org with SMTP; 4 Jan 2004 23:55:22 -0000
Received: (qmail 10183 invoked from network); 4 Jan 2004 23:50:12 -0000
Received: from unknown (HELO backstagetech.com.au) (203.217.17.173)
  by mail.iinet.net.au with SMTP; 4 Jan 2004 23:50:11 -0000
Message-ID: <3FF8A6AB.4080402@backstagetech.com.au>
Date: Mon, 05 Jan 2004 10:50:03 +1100
From: Scott Eade <seade@backstagetech.com.au>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.5) Gecko/20031007
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Apache Torque Users List <torque-user@db.apache.org>
Subject: Re: autoIncrement in PostgreSQL
References: <200401042244.46526.thomas@lohmueller.ch>
In-Reply-To: <200401042244.46526.thomas@lohmueller.ch>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org