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

pgMigrate

From: "Brett Maton" <matonb(at)hotmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: pgMigrate
Date: 2002-01-11 15:15:11
Message-ID: F74v60gxapzhad2VqKw0000209b@hotmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
Hi,

  I have a problem with the Migration wizard, basically it chokes on a date 
field for some reason, it reckons that the exported date is something like 
06/06/101.  Not sure where it's getting this from as it's certainly not in 
the DB.

I tried to alter pgMigrate to display the query string that was causing the 
problem (VB is not my thing so I probably just being stupid),

Err_Handler:
  txtStatus.Text = txtStatus.Text & vbCrLf & "An error occured at: " & Now & 
": " & vbCrLf & Err.Number & ": " & Replace(Err.Description, vbLf, vbCrLf) & 
vbCrLf & vbCrLf & "Rolling back..."
  txtStatus.SelStart = Len(txtStatus.Text)

**Added these two lines
  txtStatus.Text = txtStatus.Text & vbCrLf & "Query was : " & szQryStr
  txtStatus.SelStart = Len(txtStatus.Text)

  svr.Databases(szDatabase).Execute "ROLLBACK"
  txtStatus.Text = txtStatus.Text & " Done."
  txtStatus.SelStart = Len(txtStatus.Text)


but I get an error message when I try to run my modified plugin:

An error has occured in pgAdmin II:frmMain.mnuPluginsPlg_Click:

Number: 13
Description: Type mismatch

I'm not sure how the date / time is being passed to Postgres, but was 
thinking if it's sent over in a long string format (11 January 2002) pg will 
store it correctly

Brett.

_________________________________________________________________
Join the worlds largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


pgadmin-hackers by date

Next:From: Dave PageDate: 2002-01-11 15:47:46
Subject: Re: pgMigrate
Previous:From: Dave PageDate: 2002-01-11 10:32:53
Subject: Re: MS SQL Migration

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