I am CC'ing the author of the mysql conversion tool.
> I'm trying to find the right people to send this bug report to, and > Tim says you're the people, so... see attached email, please. > > -- > - Jason > > Politicians are the same all over. They promise to build a bridge even > where there is no river. > -- Nikita Khrushchev -- Start of included mail From: Tim Perdue <[EMAIL PROTECTED]> > Date: Sat, 6 Oct 2001 08:33:55 -0500 > To: Jason Spence <[EMAIL PROTECTED]> > Subject: Re: mysql2pgsql tool > Content-Disposition: inline > User-Agent: Mutt/1.3.12i > X-MIME-Autoconverted: from quoted-printable to 8bit by graendal.lightconsulting.com >id f96DeB873702 > Content-Disposition: inline; filename=mutt-graendal-74937-10 > Thanks. I didn't create that tool - the postgres team did. > > Tim > > > On Fri, Oct 05, 2001 at 09:27:32PM -0700, Jason Spence wrote: > > Hi - > > > > I'm using your mysql2pgsql tool to migrate a database over to > > PostgreSQL. Works great, except I had to do one thing: > > > > cat old-database.sql92 | sed -e 's/ TYPE=MyISAM//' -e 's/^#/--/' -e > > 's/UNIQUE KEY/UNIQUE/' > output1.sql > > > > That takes care of the comments, the new suffix appended to each > > CREATE TABLE clause, and a grammar difference in key declaration. > > > > There's also a problem with the UNIQUE clauses where MySQL wants an > > index name before the parenthesized list of columns and PostgreSQL > > just wants the list of columns immediately. I couldn't figure out how > > to fix that in sed, but maybe you can. > > > > -- > > - Jason > > > > "Well, if you can't believe what you read in a comic book, what *___can* > > you believe?!" > > -- Bullwinkle J. Moose [Jay Ward] > > -- > Founder - PHPBuilder.com / Geocrawler.com / SourceForge > Perdue, Inc. > 515-554-9520 -- End of included mail. > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
