I have still this problem migratin an sql server 2000 db to a postgresql
one.
The migration wizard throws me this error :
---------
An error occured at: 26/02/2002 9.50.15:
-2147467259: Error while executing the query;
ERROR: Bad timestamp external representation '2001-12-04 00.00.00'
------------
when trying to execute the following code :
------------
INSERT INTO "ahepatch" ("ptcodrel", "ptreleas", "ptnumpat", "ptdatins",
"ptdescri", "cpccchk") VALUES ('1.02-A0001 ', '1.2 ', '1',
'2001-12-04 00.00.00', 'Aggiornamento EURO-KIT ',
'kfdujcqkgp')
------------
I don't know how to make it works, can someone help me? Is it a bug in the
wizard or a bad representation in my source db, or what ?
Samuele.
-----Messaggio originale-----
Da: pgadmin-support-owner@postgresql.org
[mailto:pgadmin-support-owner@postgresql.org]Per conto di Samuele
Brignoli
Inviato: venerdì 15 febbraio 2002 9.51
A: pgadmin-support@postgresql.org
Oggetto: [pgadmin-support] pgadmin sql server migration timestamps
Hello,
I'm trying to migrate a sql server db to a postgresql db using pgadmin 1.2.0
migration plugin. When doing that I obtain this error :
Creating table: AHEPATCH
Copying data...
An error occured at: 15/02/2002 9.46.58:
-2147467259: Error while executing the query;
ERROR: Bad timestamp external representation '2001-12-04 00.00.00'
the field that causes the error is :
PTDATINS datetime 8
in AHEPATCH. In this column I have this date : '04/12/2001'. I don't know
which is the problem, can you help me ?
Samuele.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org