date problem
От | Martín Marqués |
---|---|
Тема | date problem |
Дата | |
Msg-id | 01050319564906.00345@bugs обсуждение исходный текст |
Ответы |
Re: date problem
|
Список | pgsql-general |
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 -----------------------------------------------------------------
В списке pgsql-general по дате отправления: