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.