I have a function that I've used since early postgres-7.x days. Now migrating
to a 64-bit
(i7) machine - running 2.6.30/'squeeze' with postgresql-8.4.1-1. This function
is a simple
one that takes a string representation of a number as its sole argument
(engineering
notation), and returns the number. The floating point value that it returns is
the same
value {6.94822224692498e-310} with every call, even when the string changes.
The same function works perfectly on a separate 2.6.30/'squeeze'
system, PG-8.4.1-1,
that is a 32-bit system - just like it has on previous postgres versions.
If I enable a diagnostic mid-functon dump-to-a-file, I can see that the
function
is receiving its input and computing the output properly - it's "just" a matter
of
getting the output translated into sql-land. This is with the "Version 0"
calling
conventions, with a return type of float8* . Attempting "Version 1" calling
conventions
on the 64-bit system has not yet been successful - I haven't yet been able to
avoid a client
segfault, whether I use a stack variable for the float8 result, or use palloc().
In case it would help, the key parts of the function are:
float8 *sick_fct(const char *strng)
{
float8 *result;
char stack_string_buffer[BIG_STRING_SPACE];
// string copy operation : strng -> stack_string_buffer
...
result= (float8*)palloc(sizeof(float8));
*result= inner_conversion_function(stack_string_buffer);
// printing this *result to a file shows that the conversion is correct
// the mysteriously wrong part seems to be:
return result;
}
I'm compiling it as:
g++-4.3 -c -I/usr/include -I/usr/lib/gcc/x86_64-linux-gnu/4.3/include
-Wall -Wshadow -Wpointer-arith -Wcast-align -I/usr/include/postgresql -I(yet
more includes) -fPIC -x c sick_fct.c -o sick_fct.o
and building the library as:
g++-4.3 -shared -Wl,-soname,lib_sickfct.so.1 -o lib_sickfct.so.1.0 *.o
and "creating" the function within PG as:
CREATE OR REPLACE FUNCTION sick_fct(text) RETURNS float
AS '/lib-path/lib_sickfct', 'sick_fct' LANGUAGE C STRICT;
Note that changing the "float" on the last line to "double precision" changes
nothing.
Odds are that I'm doing something stupid, but so far I haven't figured
out
what it is. Thanks for any insights you might have!
-f
--
To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
