mysql2pgsql.perl update

From: Andrew Hammond <andrew(dot)george(dot)hammond(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: mysql2pgsql.perl update
Date: 2011-02-28 17:50:34
Message-ID: AANLkTik=gN7A5uuHKPRaB-wm42bTx8PN3VCRDw7qFF+S@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)george(dot)hammond(at)gmail(dot)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(dot)george(dot)hammond(at)gmail(dot)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(dot)george(dot)hammond(at)gmail(dot)com>
Date: Sat Feb 26 12:22:32 2011 -0800

replace \\ with \\\\

commit d730da318da301157783bf15c6add3e58e32b57e
Author: Andrew Hammond <andrew(dot)george(dot)hammond(at)gmail(dot)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(dot)george(dot)hammond(at)gmail(dot)com>
Date: Sat Feb 26 12:08:40 2011 -0800

whitespace & indenting normalization

commit 4281e1c314501f4209245ac55d31f1e43b4ddc21
Author: Andrew Hammond <andrew(dot)george(dot)hammond(at)gmail(dot)com>
Date: Sat Feb 26 11:58:52 2011 -0800

pgfoundry version 2007-12-04 17:29

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-02-28 17:59:56 Re: Snapshot synchronization, again...
Previous Message Peter Eisentraut 2011-02-28 17:45:45 Re: pl/python custom exceptions for SPI