Re: [galaxy-dev] PostgreSQL issue: reserved keyword used as identifier

2011-04-09 Thread Louise-Amélie Schmitt
On Fri, 8 Apr 2011 16:33:58 -0400, Kanwei Li kan...@gmail.com wrote: Hi Louise, Have you considered doing a SQL dump and import? Sounds easier to me than writing a perl script ;) -K Oh yes I did... Yeah, that solution sounded so sweet that is was the first thing I tried. But don't be

[galaxy-dev] PostgreSQL issue: reserved keyword used as identifier

2011-04-08 Thread Louise-Amélie Schmitt
Hello everyone I just met a huge problem concerning the database. I'm currently trying to transfer my data from MySQL to PostgreSQL by writing a Perl script that would do the job. Here is the issue: In the form_definition table, one of the field identifiers is desc, which is a reserved SQL

Re: [galaxy-dev] PostgreSQL issue: reserved keyword used as identifier

2011-04-08 Thread Louise-Amélie Schmitt
Le vendredi 08 avril 2011 à 11:12 -0400, Sean Davis a écrit : 2011/4/8 Louise-Amélie Schmitt louise-amelie.schm...@embl.de: Hello everyone I just met a huge problem concerning the database. I'm currently trying to transfer my data from MySQL to PostgreSQL by writing a Perl script that

Re: [galaxy-dev] PostgreSQL issue: reserved keyword used as identifier

2011-04-08 Thread Kanwei Li
Hi Louise, Have you considered doing a SQL dump and import? Sounds easier to me than writing a perl script ;) -K 2011/4/8 Louise-Amélie Schmitt louise-amelie.schm...@embl.de: Le vendredi 08 avril 2011 à 11:12 -0400, Sean Davis a écrit : 2011/4/8 Louise-Amélie Schmitt

Re: [galaxy-dev] PostgreSQL issue: reserved keyword used as identifier

2011-04-08 Thread Brad Chapman
Louise-Amélie; I just met a huge problem concerning the database. I'm currently trying to transfer my data from MySQL to PostgreSQL by writing a Perl script that would do the job. I've used this ruby script to convert a Galaxy MySQL database to PostgreSQL: