Re: 'sequence' table?

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

--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