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