Re: 'sequence' table?

[prev] [thread] [next] [Date index for 2004/09/18]

just use your imagination, there are many alternatives.  i agree, it's 
playing with fire to tread on any reserved keywords.

tablename ideas: seq, feature, region, residues, protein...

-ad

On Fri, 17 Sep 2004, Charles Bailey wrote:

> --On Friday, September 17, 2004 5:17 PM +0100 Dave Howorth 
> <dhoworth@xxxxxxx.xxx.xx.xx> wrote:
> 
> > Is it possible to have a table called 'sequence'?
> >
> > I work with proteins, so sequence is kind of an important concept in the
> > problem domain :)  I'm using Maypole, so I want/need the table name to be
> > determined by the GUI requirements.
> >
> > When I use a database with a 'sequence'table, I see the following error:
> >
> >    Column 'sequence' in QD1::Entry clashes with built-in method at
> >    /usr/local/share/perl/5.6.1/Class/DBI/Loader/mysql.pm line 24
> >
> > This is caused by error checking in Class::DBI because it has a method
> > called 'sequence'. I believe I don't need the method because I'm using
> > mysql. Is it possible to dispense with the method so I can use the name?
> 
> You could comment out the warning, but this might come back to haunt you if 
> you ever switch DBMS, or if a future version of MySQL picks it up as a 
> reserved word.  Could you get by with something like "AASequence", or even 
> "Amino_acids", or head in the other direction with an abbreviation like 
> "Seq"?
> 
> --
> Regards,
> Charles Bailey  < bailey _at_ newman _dot_ upenn _dot_ edu >
> Newman Center at the University of Pennsylvania
>