Re: pgAdminII 1.4.12 crash with PostgreSQL 7.3

Comments below prefixed DP.

_____________Original message ____________
Subject:    Re: [pgadmin-support] pgAdminII 1.4.12 crash with PostgreSQL 7.3
Sender:    "Didier Moens" <moensd@xs4all.be>
Date:        Thu, 26 Dec 2002 15:23:13 +0000

Hi Dave,


A merry Christmas to you (and your beloved ones), and all pgAdmin
developers.

DP: Thanks, and to you as well.

Dave Page wrote:

>Hi Didier,
>
>Glad it's working now. It might be worth mentioning in your report, that
>the error appears to be coming from MDAC rather than pgAdmin. It appears
>the MDAC (or a component of it that pgAdmin uses) is being destroyed for
>some reason. The error message you are getting is basically the same as
>you get from an app when you are debugging a COM object in VB that the
>app is using, and you stop the debug.
>

I filed a bug report with RedHat :
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=80394

It would be much appreciated, if you can add your comments (as I'm not a
VB developer).

DP: I'll take a look.

On a related note :


1. Access2K database migration with 1.4.12 is approx. 6 to 8 times
slower than previous versions (20 minutes -> over two hours), mainly in
the Foreign Key creation, it seems. I'll check if this is due to pgAdmin
(1.4.0 -> 1.4.12) or PostgreSQL (7.2.x -> 7.3).

DP: Check you have logging set to none or errors only. The code has had few changes.

2. Total migration execution time doesn't wrap around :
...
Creating Foreign Key: invoicesstock
Creating Foreign Key: ordersstock
Creating Foreign Key: balancessubjobs3
Creating Foreign Key: budgetssubjobs3

Migration finished at: 24/12/2002 0:20:16, taking -77438,65 seconds.

DP: Odd, VB doesn't wrap values like C etc, you get an overflow error instead.

3. The 'default values' of my Access2K fields do not get migrated : is
this a bug or a missing feature ?

DP: Defaults are always problematic, not just due syntax differences in expressions. Iirc, in ADO we can't even see the
defaultsfor most oledb providers, so we don't migrate them   

Regards, Dave.