date problem

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
-----------------------------------------------------------------

Responses

Browse pgsql-general by date

  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