Skip site navigation (1) Skip section navigation (2)

Re: LibPqEasy, binary cursor, x86-64, fetch(int4) problem?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Mariano Reingart <mariano(at)nsis(dot)com(dot)ar>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: LibPqEasy, binary cursor, x86-64, fetch(int4) problem?
Date: 2006-02-12 15:53:03
Message-ID: 20060212155303.GA68917@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Sat, Feb 11, 2006 at 08:28:25PM -0300, Mariano Reingart wrote:
> Hi, I recently moved a simple application from a 32bit Intel to a new AMD64 
> server (migrated from Postgres 7.2 to 8.1.2 and LibPqEasy 3.0.4), running 
> Slamd64 (Slackware port to the AMD64). Everything compiled just fine but 
> the applicattion didn't work as expected.
> When I look into the tables (with psql) I see strange values in int4 
> columns like ( 16777216, 402653184, 1124073472, ...) instead of normal ones 
> (1, 24, 67)

Convert the numbers to hex and they don't look so strange:

1  = 0x01
24 = 0x18
67 = 0x43

16777216   = 0x01000000
402653184  = 0x18000000
1124073472 = 0x43000000

That ought to hint at what's happening.

-- 
Michael Fuhr

In response to

pgsql-interfaces by date

Next:From: Jan KlostermannDate: 2006-02-12 22:59:10
Subject: unsubscribe
Previous:From: Christoph ZwerschkeDate: 2006-02-12 09:19:42
Subject: Re: Finding the pqlib version

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group