db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kris Nuttycombe" <Kris.Nuttyco...@noaa.gov>
Subject Re: Key problems - Torque 3.1.1
Date Mon, 15 Nov 2004 21:08:41 GMT
Unfortunately, I don't think that's the issue. It was one of my first 
thoughts, as well. Here's the desc of the table:

mysql> desc data_info;
+----------------+---------------+------+-----+---------+-------+
| Field          | Type          | Null | Key | Default | Extra |
+----------------+---------------+------+-----+---------+-------+
| id             | int(11)       |      | PRI | 0       |       |
| title          | varchar(100)  | YES  |     | NULL    |       |
| data_source_id | int(11)       |      |     | 0       |       |
| fgdc_number    | varchar(24)   | YES  |     | NULL    |       |
| last_update    | timestamp(14) | YES  |     | NULL    |       |
+----------------+---------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

And my schema.xml entry is listed below, from my initial post.

Could it be the default value that's throwing it off?

Kris

Guy Galil wrote:

>I think the problem is with the id being an auto increment column - if u
>set it to be autoIncrement="false" on the target database then you will
>be able to put the correct value in there.
>Guy
>

>On Mon, 2004-11-15 at 14:53, Kris Nuttycombe wrote:
>  
>
>><snip/>
>>
>>According to the log, the destination data_info entry looks right. 
>>Here's the schema.xml entry for the data_info table:
>>
>>    <table name="data_info">
>>        <column name="id" type="INTEGER" primaryKey="true" required="true"/>
>>        <column name="title" size="100" type="VARCHAR"/>
>>        <column name="data_source_id" required="true" type="INTEGER"/>
>>        <column name="fgdc_number" size="24" type="VARCHAR"/>
>>        <column name="last_update" type="TIMESTAMP"/>
>>       
>>        <foreign-key foreignTable="data_source">
>>            <reference local="data_source_id" foreign="id"/>
>>        </foreign-key>
>>    </table>
>>
>>    
>>

-- 
=====================================================
Kris Nuttycombe
Associate Scientist
Geospatial Data Services Group
CIRES, National Geophysical Data Center/NOAA
(303) 497-6337
Kris.Nuttycombe@noaa.gov
=====================================================



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


Mime
View raw message