Hi Ken, Actually, I figured out what the problem was. The sql has lines like this:
grant all on cell_line_cell_line_id_seq to PUBLIC; which SQLT chokes on: Error: translate: Error with parser 'SQL::Translator::Parser::PostgreSQL': Couldn't create table 'cell_line_synonym_cell_line_synonym_id_seq': Can't create table: "" exists at /Library/Perl/5.8.8/SQL/Translator/Parser/PostgreSQL.pm line 1034. but apparently, that message wasn't making it to stderr or stdout before (probably because of the crazy method I was using with the scripts that Allen wrote years ago). Anyway, it seems like SQLT's PostgreSQL parser should be able to handle this, but apparently not. I took those lines out of the sql for now, and it's not even clear to me that they are needed anyway. Thanks, Scott On Aug 28, 2009, at 1:44 PM, Scott Cain wrote: > Hi Ken, > > I just wanted to let you know that with the svn version of SQLT, > diagram and graphviz applications are now working for me. I didn't > do anything special, so I don't know what was wrong before. > > Thanks, > Scott > > > On Aug 26, 2009, at 12:30 PM, Ken Youens-Clark wrote: > >> On Aug 25, 2009, at 3:20 PM, Scott Cain wrote: >> >>> Hi Ken, >>> >>> I was pretty sure you were a Mac person, and therefore, SQLT >>> probably worked fine on a Mac. I'll try to simplify and figure >>> out what the problem is and get back to you on the skip_tables >>> stuff, though I suspect I'd like to have it. :-) >>> >>> Thanks, >>> Scott >> >> Scott, >> >> I've added this code. >> >> ky > > ----------------------------------------------------------------------- > Scott Cain, Ph. D. scott at scottcain dot net > GMOD Coordinator (http://gmod.org/) 216-392-3087 > Ontario Institute for Cancer Research > > > > ----------------------------------------------------------------------- Scott Cain, Ph. D. scott at scottcain dot net GMOD Coordinator (http://gmod.org/) 216-392-3087 Ontario Institute for Cancer Research ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july -- sqlfairy-developers mailing list sqlfairy-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
