[ic] DatabaseAuto and auto_increment
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 ...
End Point Corporation
More information about the interchange-users