On Tue 31 May 2005 (19:06 +0200), Holger wrote: > On Tue, 10 May 2005 08:28:43 +0200, Jim Segrave wrote: > > The table name 'match' is a reserved word in mysql, making it not > > possible to use mysql with gnubg. > > You can quote all names of databases, tables, columns and aliases with > backticks (`match`) and thus use reserved words or spaces.
Yep, but that's going to have an impact on database.py and gnubg.sql. I'd think it's better to have names which don't need escaping > > 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? > > This will only change this table, not any other table or a constraint > of that table to the table being changed. Therefore these tables must > also be altered. (ALTER TABLE DROP FOREIGN KEY ... ; ALTER TABLE ... > ADD FOREIGN KEY ... REFERENCES ...) > > Regards, > > Holger -- Jim Segrave [EMAIL PROTECTED] _______________________________________________ Bug-gnubg mailing list [email protected] http://lists.gnu.org/mailman/listinfo/bug-gnubg
