Unix Technical Forum

int64 and spi_getbinval bug !?

This is a discussion on int64 and spi_getbinval bug !? within the pgsql Bugs forums, part of the PostgreSQL category; --> Hi My version of postgresql is: PostgreSQL 8.0.4 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3 20051201 (prerelease) (Debian ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Bugs

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 10:01 AM
=?ISO-8859-1?Q?Germ=E1n_Aracil_Boned?=
 
Posts: n/a
Default int64 and spi_getbinval bug !?

Hi

My version of postgresql is:
PostgreSQL 8.0.4 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3
20051201 (prerelease) (Debian 4.0.2-5)

I don't cat get real value of int64 fields. spi_get_binval return wrong
values. But it works with int32.

best regards

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-10-2008, 10:01 AM
Alvaro Herrera
 
Posts: n/a
Default Re: int64 and spi_getbinval bug !?

Germán Aracil Boned wrote:

> My version of postgresql is:
> PostgreSQL 8.0.4 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3
> 20051201 (prerelease) (Debian 4.0.2-5)


You should update to 8.0.8 ...

> I don't cat get real value of int64 fields. spi_get_binval return wrong
> values. But it works with int32.


Maybe you put wrong values in the attrs. How would we know if you
haven't shown us any code?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:39 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com