Hi. Are you sure it's for me ? In the bugreport said about mysql2pgsql, however I'm the author of my2pg.pl. Both tools are distributed with Postgres source distribution. Please confirm that's really for me.
Thanks. Max Rudensky. On Wed, 10 Oct 2001 15:45:22 -0400 (EDT) Bruce Momjian <[EMAIL PROTECTED]> wrote: > 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
