db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Lohmueller <tho...@lohmueller.ch>
Subject autoIncrement in PostgreSQL
Date Sun, 04 Jan 2004 21:44:46 GMT

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="" />

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

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

Any ideas? Thanks,


To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message