Re: [tim@perdue.net: Re: mysql2pgsql tool]

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