After converting a mysql database to PG, I try to dump it to my Pg database
and I get 5 times in more the 500 inserts this error:
ERROR: Bad date external representation '1999-02-30'
<after looking at the calendar>
I notice that the dates that failed don't exist.
Oh man, what a bitch MySQL is!!!!
</>after looking at the calendar
Any idea?
The other thing I don't understand is why mysql2pgsql when converting the
auto_incremental field of MySQL to PGsql puts everything OK in the table, but
then does all the inserts without creating the sequence. After all the
inserts, it creates the sequence. I think thats not the way the dump file
should go.
Any thoughts?
Saludos... :-)
--
El mejor sistema operativo es aquel que te da de comer.
Cuida tu dieta.
-----------------------------------------------------------------
Martin Marques | mmarques@unl.edu.ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------