Re: Key problems - Torque 3.1.1

A minor update - I dropped the default from the id column just to be 
sure and it didn't change the behavior.

Kris Nuttycombe wrote:

> 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@xxxxxxxx
=====================================================