Problem integrating C stub - Mailing list pgsql-novice

From Smita Vijayakumar
Subject Problem integrating C stub
Date
Msg-id 0eb3d6c9000031ac@globallogic.com
Whole thread Raw
Responses Re: Problem integrating C stub
List pgsql-novice
Hi,
While integrating C stub in stored procedure, I came across the
following problem whenever the DB triggered the SP:
"
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
"

My C code looks like this:
"
PG_FUNCTION_INFO_V1(abc);
Datum abc(PG_FUNCTION_ARGS)
{
    VarChar *arg1 ;
    char *str;
    arg1=(VarChar *) PG_GETARG_VARCHAR_P(0);
    int str1Size = VARSIZE(arg1) - VARHDRSZ;
    if (arg1) str = (char *) VARDATA(arg1);
    short int ret ;

    str[str1Size]='\0';
    ret =anotherfunc(str); // anotherfunc() returns smallint

    PG_RETURN_INT16(ret);
}
"

I am not sure what I am doing wrong, but I notice whenever I comment out
the code for extraction of the arguments,
"
        arg1=(VarChar *) PG_GETARG_VARCHAR_P(0);
        int str1Size = VARSIZE(arg1) - VARHDRSZ;
        if (arg1) str = (char *) VARDATA(arg1);
"
the DB ceases to throw the error.

The function has been declared as
"
CREATE FUNCTION abc(varchar) RETURNS smallint AS '/path/abc.so', 'abc'
LANGUAGE C STRICT;
"

Am I missing something?

Thanks,
Smita

pgsql-novice by date:

Previous
From: "Oeschey, Lars (I/EK-142, extern)"
Date:
Subject: sync two databases
Next
From: Tom Lane
Date:
Subject: Re: Problem integrating C stub