On Tue, May 10, 2005 at 08:28:43AM +0200, Jim Segrave wrote: > > The table name 'match' is a reserved word in mysql, making it not > possible to use mysql with gnubg. Changing the table name to someghing > like bgmatch in database.py and gnubg.sql would solve this problem and > make it possible for other databases to be used - I've already had a > private query from someone about using Oracle. > > If we do change it, does anyone know if you can just do > > ALTER TABLE match RENAME TO bgmatch; > > and have that also change the constraints for an existing database? > If so, and it is decided to rename the table, perhaps we should have a > fixup script for existing databases?
There are ways around it in mysql if I'm not mistaking, but the most user friendly thing is to change the table name indeed I guess. :) Marco - Still lurking this list. -- Je moet me niet dood maken met een blije mus _______________________________________________ Bug-gnubg mailing list [email protected] http://lists.gnu.org/mailman/listinfo/bug-gnubg
