From: | Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | date problem |
Date: | 2001-05-03 16:56:49 |
Message-ID: | 01050319564906.00345@bugs |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)unl(dot)edu(dot)ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Richardson | 2001-05-03 17:00:47 | Re: Unique or Primary Key? |
Previous Message | Roger Wernersson | 2001-05-03 16:29:23 | optimizing |