[ic] DatabaseAuto and auto_increment

Jon Jensen jon at endpoint.com
Wed Nov 2 14:40:44 EST 2005

On Wed, 2 Nov 2005, JT Justman wrote:

> I've recently set up DatabaseAuto on first my testing and now production
> servers. I neglected to notice, however, that for tables with
> auto_incriment set, IC still tries to set an index in the UI. If I set
> like this:
> Database table_name AUTO_SEQUENCE 1
> in catalog/db config, as I had before, it seems to work. But, the point
> of using DatabaseAuto was to avoid having to specify such things for
> each table, and I've got tons of custom tables.

Does that really work with MySQL? Does MySQL 4.1 have sequences? They are 
different than AUTO_INCREMENT columns. I believe you should be supplying 
the sequence name, not a boolean '1'. But I haven't tried it.

> I was looking at the DatabaseDefault code and it's a tad over my head. I
> can only imagine that there is some kind of magic going on that pulls
> the hash of the table info from DBI. Is there an existing mechanism that
> can help me out here?

I'm not aware of any. It would be nice to have. Still, using DatabaseAuto 
saves you a fair amount of manual configuration even if you still need to 
specify sequences separately ...


Jon Jensen
End Point Corporation

More information about the interchange-users mailing list