Skip site navigation (1) Skip section navigation (2)

R: timestamp parse error --- *** Migration PLU

From: "Samuele Brignoli" <samuele(dot)brignoli(at)darpha(dot)com>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>,<pgadmin-support(at)postgresql(dot)org>
Subject: R: timestamp parse error --- *** Migration PLU
Date: 2002-04-03 13:33:34
Message-ID: CNEDLAJNHCDEGDBGOHHCIEGNCOAA.samuele.brignoli@darpha.com (view raw or flat)
Thread:
Lists: pgadmin-support
ok Dave,

that was the problem : my client's locale was Italian instead of US English.
Now it works
perfectly also on my big db. Thanks for support me, you' re great.

	Samuele.

-----Messaggio originale-----
Da: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org]Per conto di Dave Page
Inviato: Wednesday, April 03, 2002 10:21 AM
A: 'samuele(dot)brignoli(at)darpha(dot)com'; pgadmin-support(at)postgresql(dot)org
Oggetto: Re: [pgadmin-support] timestamp parse error --- *** Migration
PLU




> -----Original Message-----
> From: Samuele Brignoli [mailto:samuele(dot)brignoli(at)darpha(dot)com]
> Sent: 28 March 2002 11:30
> To: Dave Page
> Subject: R: [pgadmin-support] timestamp parse error --- ***
> Migration PLU
>
>
> Ok Dave, here you are.
>
> Test creation create a table "Test" with only a datetime
> field. TestData is the data export ( but you can also insert
> a simple date like 10/10/2002 ). If you try to migrate this
> table with the plugin the usual error is generated (
> migrating the data, not generating the table ). Hope this help.

That migrates perfectly here from SQL Server 2000 to PostgreSQL 7.2/Cygwin.
The following extract from my logfile shows the migration:

2002-04-03 09:07:46 - Executing Plugin: Database Migration Wizard v1.3.21
2002-04-03 09:07:54 - Opening and Examining Source Database...
2002-04-03 09:07:54 - Opening connection: CATBERT Database: dave
2002-04-03 09:07:56 - Opened connection: Provider=SQLOLEDB.1;Integrated
Security=SSPI;Extended Properties="server=CATBERT;database=dave";Use
Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation
ID=PC9;Use Encryption for Data=False;Tag with column collation when
possible=False
2002-04-03 09:07:56 - Provider: SQLOLEDB.1 v2.7
2002-04-03 09:07:56 - Quote Character: '"'
2002-04-03 09:07:56 - Done - 2.15 Secs.
2002-04-03 09:07:56 - Looking for possible target databases...
2002-04-03 09:07:56 - Done - 0 Secs.
2002-04-03 09:08:01 - Searching for Foreign Keys...
2002-04-03 09:08:01 - Done - 0 Secs.
2002-04-03 09:08:03 - Migrating database...
2002-04-03 09:08:03 - Migration from Provider=SQLOLEDB.1;Integrated
Security=SSPI;Extended Properties="server=CATBERT;database=dave";Use
Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation
ID=PC9;Use Encryption for Data=False;Tag with column collation when
possible=False to helpdesk starting.
2002-04-03 09:08:03 - NOT NULL rules being honoured.
2002-04-03 09:08:03 - SQL (helpdesk): BEGIN
2002-04-03 09:08:03 - Creating table: Test
2002-04-03 09:08:03 - SQL (helpdesk): CREATE TABLE "Test" ( "date" timestamp
)
2002-04-03 09:08:03 - Migrating Data from: Test
2002-04-03 09:08:03 - Executing: SELECT * FROM "Test"
2002-04-03 09:08:03 - SQL (helpdesk): INSERT INTO "Test" ("date") VALUES
('1900-01-01 00:00:00')
2002-04-03 09:08:03 - SQL (helpdesk): INSERT INTO "Test" ("date") VALUES
('1900-01-01 00:00:00')
2002-04-03 09:08:03 - SQL (helpdesk): INSERT INTO "Test" ("date") VALUES
('1900-01-01 00:00:00')
2002-04-03 09:08:03 - SQL (helpdesk): INSERT INTO "Test" ("date") VALUES
('2002-12-25 00:00:00')
2002-04-03 09:08:03 - SQL (helpdesk): INSERT INTO "Test" ("date") VALUES
('2002-12-24 00:00:00')
2002-04-03 09:08:03 - SQL (helpdesk): INSERT INTO "Test" ("date") VALUES
('2001-12-24 00:00:00')
2002-04-03 09:08:03 - Records Copied: 6
2002-04-03 09:08:03 - SQL (helpdesk): COMMIT
2002-04-03 09:08:03 - Migration Completed!
2002-04-03 09:08:03 - Done - 0.48 Secs.

All I can suggest is that you double check your date format under 'Regional
Settings' on both your client and server.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly


In response to

pgadmin-support by date

Next:From: Dave PageDate: 2002-04-03 15:56:07
Subject: Re: SQL query editor
Previous:From: tulasiDate: 2002-04-03 10:39:37
Subject: pg_dump error..

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group