Problem integrating C stub

Поиск
Список
Период
Сортировка
От Smita Vijayakumar
Тема Problem integrating C stub
Дата
Msg-id 0eb3d6c9000031ac@globallogic.com
обсуждение исходный текст
Ответы Re: Problem integrating C stub  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Oeschey, Lars (I/EK-142, extern)"
Дата:
Сообщение: sync two databases
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Problem integrating C stub