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(at)xs4all(dot)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 defaults for most oledb providers, so we don't migrate them

Regards, Dave.