mysql2pgsql.perl update - Mailing list pgsql-hackers

From Andrew Hammond
Subject mysql2pgsql.perl update
Date
Msg-id AANLkTik=gN7A5uuHKPRaB-wm42bTx8PN3VCRDw7qFF+S@mail.gmail.com
Whole thread Raw
Responses Re: mysql2pgsql.perl update
List pgsql-hackers
Hi all.

I spent some time updating mysql2pgsql.perl. Changes were driven by an
attempt to migrate a redmine database. Original code was failing for a
number of reasons (regex recursion explosion, . I was wondering it
there's a more formal / appropriate place to put this. I'd also
appreciate a separate set of eyes on my changes. I grabbed an initial
copy from http://pgfoundry.org/projects/mysql2pgsql/
Git repo of the changes at
https://github.com/SmartReceipt/mysql2pgsql/commits/master/

Commit history follows.

commit 3cbe2cfa8782d250e5c4ee814c4585c96105fb45 (HEAD, sr/master,
origin/master, master)
Author: Andrew Hammond <andrew.george.hammond@gmail.com>
Date:   Sat Feb 26 12:36:36 2011 -0800
   simplify handling of mysql autoincrement to use serial8 datatype

commit 5c559b7073e6f6e72ce11f0f45be4d13cc30fd9a
Author: Andrew Hammond <andrew.george.hammond@gmail.com>
Date:   Sat Feb 26 12:26:46 2011 -0800
   multi-value inserts are supported in pgsql as of 8.2 and way faster

commit f5798a7911e5114378fd4764a62288e1826f6b56
Author: Andrew Hammond <andrew.george.hammond@gmail.com>
Date:   Sat Feb 26 12:22:32 2011 -0800
   replace \\ with \\\\

commit d730da318da301157783bf15c6add3e58e32b57e
Author: Andrew Hammond <andrew.george.hammond@gmail.com>
Date:   Sat Feb 26 12:11:49 2011 -0800
   best practices for handling quoted strings and use lookahead
rather than unnecessary match and replace

commit 20610fcb50d082e2c46bf27190e4d30dba966c27
Author: Andrew Hammond <andrew.george.hammond@gmail.com>
Date:   Sat Feb 26 12:08:40 2011 -0800
   whitespace & indenting normalization

commit 4281e1c314501f4209245ac55d31f1e43b4ddc21
Author: Andrew Hammond <andrew.george.hammond@gmail.com>
Date:   Sat Feb 26 11:58:52 2011 -0800
   pgfoundry version 2007-12-04 17:29


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pl/python custom exceptions for SPI
Next
From: Tom Lane
Date:
Subject: Re: Snapshot synchronization, again...