[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bug-gnubg] Relational database minor change suggestion

From: Jim Segrave
Subject: Re: [Bug-gnubg] Relational database minor change suggestion
Date: Wed, 1 Jun 2005 19:13:16 +0200
User-agent: Mutt/

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 ...
> Regards,
>       Holger

Jim Segrave           address@hidden

reply via email to

[Prev in Thread] Current Thread [Next in Thread]