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 <tim@perdue.net>
> Date: Sat, 6 Oct 2001 08:33:55 -0500
> To: Jason Spence <thalakan@technologist.com>
> 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
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026