Extending PostgreSQL on Windows

Hi I intalled postgreSQL 8.0.3 from win installer.
I am trying to create my own c functions to exetend the functionallity of postgres. I had some trouble so I tryed add_one function as it is shown in the documentation. When I use the old convention I am able to run the function fine when I use the new convention with the macros after i call the function I get the following error:
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

After playing with it a little I came if a conclusion that the arguments or the fcinfo struct is not properly initialized since the code breaks only when I try to access the arguments either through the macros or directly. My IDE is VS.NET 2003
The code that brakes is the following:

PG_FUNCTION_INFO_V1(add_one);

Datum

add_one(PG_FUNCTION_ARGS)

{

int32 arg = PG_GETARG_INT32(0);

PG_RETURN_INT32(arg);

}

But the following works:

Datum

add_one(PG_FUNCTION_ARGS)

{

FunctionCallInfo fcc;

fcc = (struct FunctionCallInfoData *)malloc(sizeof(struct FunctionCallInfoData));

fcc->nargs = 4;

return (int32)fcc->nargs;

}

Any help will be appreciated.

email:kostadin_m(at)yahoo(dot)com

---------------------------------
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football