Comments below prefixed DP. _____________Original message ____________ Subject: Re: [pgadmin-support] pgAdminII 1.4.12 crash with PostgreSQL 7.3 Sender: "Didier Moens" <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
