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

2011-04-09 Thread Louise-Amélie Schmitt
On Fri, 8 Apr 2011 19:02:23 -0400, Brad Chapman wrote: > 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 thi

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 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 fooled by the a

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: https://github.com

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 : > Le vendredi 08 avril 2011 à 11:12 -0400, Sean Davis a écrit : >> 2011/4/8 Louise-Amélie Schmitt : >> > Hello everyone >> > >> > I just met a huge pr

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

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

2011-04-08 Thread Sean Davis
2011/4/8 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 > id

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