Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-04 Thread Dave Page
On Thu, Mar 4, 2010 at 1:54 AM, Scott Marlowe scott.marl...@gmail.com wrote: On Wed, Mar 3, 2010 at 6:45 PM, Greg Sabino Mullane g...@turnstep.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 It's way crazier than you'd ever expect. Both the 32-bit and 64-bit versions are

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-04 Thread Richard Huxton
On 04/03/10 01:35, Craig Ringer wrote: Argh - a follow-up re ODBC 32 and 64 bit-ness: http://blog.danovich.com.au/2010/02/02/odbc-settings-on-64-bit-servers/ It's way crazier than you'd ever expect. Both the 32-bit and 64-bit versions are called odbcad32.exe but are in different (but not

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-04 Thread Justin Graf
On 3/4/2010 3:51 AM, Richard Huxton wrote: On 04/03/10 01:35, Craig Ringer wrote: http://support.microsoft.com/kb/942976/en-us Classy. Even better - according to the linked page, the 64 bit version is in the System32 folder - yippee! * The 32-bit version of the Odbcad32.exe file is

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-04 Thread Greg Stark
On Thu, Mar 4, 2010 at 2:14 PM, Justin Graf jus...@magwerks.com wrote: To pretty much anyone outside MS, a sane human would think 64 bit apps in SysWoW64 and 32Bit apps in System32. :'( Ah, but you all are forgetting that the 32 here is to distinguish it from the default odbc interface which

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-04 Thread Justin Graf
On 3/4/2010 10:00 AM, Greg Stark wrote: On Thu, Mar 4, 2010 at 2:14 PM, Justin Grafjus...@magwerks.com wrote: To pretty much anyone outside MS, a sane human would think 64 bit apps in SysWoW64 and 32Bit apps in System32. :'( Ah, but you all are forgetting that the 32 here is to

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-04 Thread Scott Marlowe
This reminds me of the joke, How many MS employees does it take to change a lightbulb? None, they just redefine dark as light. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Scratching my head why results are different between machines.

2010-03-03 Thread Michael Gould
I have several tables in a SQL Anywhere 10 database that I'm converting to PostgreSQL 8.4.2.  In ASA we did not use any GUID columns but we are in Postgres. I have one table that is citystateinfo and the primary key is a UUID and it is automatically generated using the contrib module oosp-uuid. 

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-03 Thread Justin Graf
On 3/3/2010 3:40 PM, Michael Gould wrote: On my machine the UUID that is returned is 16 bytes and I cannot make out any relevant numbers from the UUID key in the citystateinfo table. I've tried this in a Windows XP machine and a Windows 7 64 bit. Now here is the weird thing. I did a

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-03 Thread Michael Gould
Justin Graf jus...@magwerks.com wrote: On 3/3/2010 3:40 PM, Michael Gould wrote: On my machine the UUID that is returned is 16 bytes and I cannot make out any relevant numbers from the UUID key in the citystateinfo table. I've tried this in a Windows XP machine and a Windows 7 64 bit. Now

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-03 Thread Michael Gould
One thing I've noticed is that on my machines, when I install the odbc driver I get no error messages but when I look in the ODBC administrator I do not see any entry for PostGres in the drivers list. I do know that it somehow is working because the DMC conversion tool only uses ODBC and builds

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-03 Thread Justin Graf
On 3/3/2010 5:16 PM, Michael Gould wrote: One thing I've noticed is that on my machines, when I install the odbc driver I get no error messages but when I look in the ODBC administrator I do not see any entry for PostGres in the drivers list. I do know that it somehow is working because the

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-03 Thread Michael Gould
Is there anyone out there using Windows 7 64 bit with Postgres 8.4.2 and the psqlodbc driver?  I've tried to install using the one that is available with the standard windows installer.  I've also tried to install with the one from EDB.   It appears that the installer finishes the install but when

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-03 Thread Craig Ringer
Michael Gould wrote: Does anyone have any idea on what is going on here and how to fix the problem? I've logged in as the domain adminstrator and the system administrator for our domain and I've turned UAC off also, but as of yet no luck. I'm wondering if you should post to the pgsql-odbc

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-03 Thread Craig Ringer
Argh - a follow-up re ODBC 32 and 64 bit-ness: http://blog.danovich.com.au/2010/02/02/odbc-settings-on-64-bit-servers/ It's way crazier than you'd ever expect. Both the 32-bit and 64-bit versions are called odbcad32.exe but are in different (but not distinctively named) locations.

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-03 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 It's way crazier than you'd ever expect. Both the 32-bit and 64-bit versions are called odbcad32.exe but are in different (but not distinctively named) locations. http://support.microsoft.com/kb/942976/en-us Wow. If I even had the

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-03 Thread John R Pierce
Greg Sabino Mullane wrote: Wow. If I even had the slightest regret about my move to abandon Windows years ago, this would have pretty much squashed it. Magnus et. al., I don't know how you do it. :) yeah, (l)unix systems/users/apps never get ./lib and ./lib64 mixed up, oh no. --

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-03 Thread Scott Marlowe
On Wed, Mar 3, 2010 at 6:45 PM, Greg Sabino Mullane g...@turnstep.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 It's way crazier than you'd ever expect. Both the 32-bit and 64-bit versions are called odbcad32.exe but are in different (but not distinctively named) locations.

Re: [GENERAL] Scratching my head why results are different between machines.

2010-03-03 Thread Scott Marlowe
On Wed, Mar 3, 2010 at 6:54 PM, John R Pierce pie...@hogranch.com wrote: Greg Sabino Mullane wrote: Wow. If I even had the slightest regret about my move to abandon Windows years ago, this would have pretty much squashed it. Magnus et. al., I don't know how you do it. :) yeah, (l)unix