Quoting Jon Jensen (suppressed): > 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? It doesn't have sequences, but we emulate the behavior with AUTO_INCREMENT. > 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. 1 is the same as a sequence name for MySQL. It wouldn't work for Postgres (certainly not more than once). > > >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 ... If the OP could explain precisely how we might intuit the AUTO_SEQUENCE behavior from the SQL configuration perhaps we would. But I think we are waiting on the Mind::Read module for Perl.... -- Mike Heins Perusion -- Expert Interchange Consulting http://www.perusion.com/ phone +1.765.647.1295 tollfree 800-949-1889 <suppressed> For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled. -- Dick Feynman _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.