[tim@perdue.net: Re: mysql2pgsql 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
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