server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>
The real problem starts here: when i use the function as
select rational_out(rational_type) from testtable;
it works fine and returns a cstring. But when i execute
select rational_type from testtable;
then it dies with the error i mentioned before. Why is it happeneing?
But the input function which takes a cstring as input is working fine.
I have initialised the datatype as:
CREATE OR REPLACE FUNCTION frational_in(cstring) RETURNS frational AS
'/root/pgsql/hier_farey/lib/libfrational.so.1' LANGUAGE C;
CREATE OR REPLACE FUNCTION frational_out(frational) RETURNS cstring AS
'/root/pgsql/hier_farey/lib/libfrational.so.1' LANGUAGE C;
CREATE OR REPLACE FUNCTION frational_in(cstring) RETURNS frational AS
'/root/pgsql/lib/libfrational.so.1' LANGUAGE C;
CREATE OR REPLACE FUNCTION frational_out(frational) RETURNS cstring AS
'/root/pgsql/lib/libfrational.so.1' LANGUAGE C;
Please help me out with this one,
thanks,
subhash.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match