SCM

Forum: bugs

Monitor Forum | Start New Thread Start New Thread
RE: Close parenthesis in field causing proble [ reply ]
By: Phillip Odam on 2007-11-24 04:29
[forum:1002860]
Fixed in revision 1.4

Thanks Jose

RE: Close parenthesis in field causing proble [ reply ]
By: Phillip Odam on 2007-09-03 13:24
[forum:1002622]
Missed commas in the inserts

MySQL

INSERT INTO table_name VALUES (1, '\')\'d');

PostgreSQL

INSERT INTO "table_name" VALUES (1, E'\')\E'd');

Close parenthesis in field causing problem [ reply ]
By: Phillip Odam on 2007-09-03 13:10
[forum:1002621]
The following MySQL

INSERT INTO form_group VALUES (1 '\')\'d');

using the command

./mysql2pgsql.perl mysql.sql postgres.sql

generates the following SQL

INSERT INTO "table_name" VALUES (1 E'\')\E'd');

Powered By FusionForge