Thread: problem with floats

I was trying to use some c code to return floats to postgres but I keep getting
the following error :

template1=> select oner();
PQexec() -- Request was sent to backend, but backend closed the channel before
responding.  This probably means the backend terminated abnormally before or
while processing the request.

The function is :
...
float8 oner() {return(1.0);}
...

And is created :
drop function oner();
DROP

create function oner() returns float8
        as '/home/acarobus/postgres/f_los.so' language 'c';
CREATE

Does anyone know why this is happening?  thanks for any help.

-Alex

> I was trying to use some c code to return floats to postgres but I keep
> getting the following error :
>
> template1=> select oner();
> PQexec() -- Request was sent to backend, but backend closed the channel before
> responding.  This probably means the backend terminated abnormally before or
> while processing the request.

From my (limited) experience, this message occurs when you fail to get a
connection to the database. I do not believe it has anything to do with
the floating point stuff you're trying, but probably more to do with your
call to PQsetdb(), environment variables, or entries in your pg_hba.conf
file.

I hope I'm not leading you in the wrong direction with this answer, but
that's what I'd be checking if I hadn't already.


Bruce Tong                 |  Got me an office; I'm there late at night.
Systems Programmer         |  Just send me e-mail, maybe I'll write.
Electronic Vision / FITNE  |
zztong@laxmi.ev.net        |  -- Joe Walsh for the 21st Century