vishal saberwal <vishalsaberwal@xxxxxxxxx> writes: > xy_db=# create or replace function file_check(varchar) returns varchar as > xy_db-# '/root/resource_test.so','file_check' language 'c'; > CREATE FUNCTION > k2_db=# select file_check('/ResourceFS/IconFS/Alarm/My.gif'); > server closed the connection unexpectedly This is not a file permissions problem ... more likely, your C function is wrong and is dumping core. Getting out your debugger would be a good response. > char *filecmd = (char*) PG_GETARG_VARCHAR_P(0); However, I can point you in the right direction: you can't just cast a varchar * to char *, they are not remotely the same thing. regards, tom lane