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

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 Graf 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 distingu

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 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 as i recall was

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.ex

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 dist

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 wrote: > On Wed, Mar 3, 2010 at 6:45 PM, Greg Sabino Mullane 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 ar

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 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 systems/use

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 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 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. -- Sen

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 s

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. http://suppo

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-odb

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 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 t

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 it

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

2010-03-03 Thread Michael Gould
"Justin Graf" 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 here i

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 c

[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.