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.hamm...@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.hamm...@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.hamm...@gmail.com> Date: Sat Feb 26 12:22:32 2011 -0800 replace \\ with \\\\ commit d730da318da301157783bf15c6add3e58e32b57e Author: Andrew Hammond <andrew.george.hamm...@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.hamm...@gmail.com> Date: Sat Feb 26 12:08:40 2011 -0800 whitespace & indenting normalization commit 4281e1c314501f4209245ac55d31f1e43b4ddc21 Author: Andrew Hammond <andrew.george.hamm...@gmail.com> Date: Sat Feb 26 11:58:52 2011 -0800 pgfoundry version 2007-12-04 17:29 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers