On Wed, Dec 9, 2009 at 8:33 AM, AlexeyChe <alexey.chernushev@xxxxxxxxx> wrote:
>
> Hi there
> Need help, I just took the example from Postgres help, code:
>
> #include "postgres.h"
> #include "fmgr.h"
>
> #ifdef PG_MODULE_MAGIC
> PG_MODULE_MAGIC;
> #endif
>
> PG_FUNCTION_INFO_V1(add_one);
>
> __declspec (dllexport) Datum add_one(PG_FUNCTION_ARGS)
> {
> int32 arg = PG_GETARG_INT32(0);
>
> PG_RETURN_INT32(arg + 1);
> }
>
> PG_FUNCTION_INFO_V1(fo);
>
> __declspec (dllexport) Datum fo(PG_FUNCTION_ARGS)
> {
> float8 arg = PG_GETARG_FLOAT8(0);
>
> PG_RETURN_FLOAT8(arg+1);
> }
>
>
>
> CREATE OR REPLACE FUNCTION "public"."add_one_f"(double precision) RETURN
> double precision AS
> 'dll_c.dll','fo'
> LANGUAGE C STRICT
>
> Select add_one_f(99)
>
>
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before OR while processing the request.
>
> Server falling down in a simple function.
> WinXP, server - Postgres 8.3, binaries for compile dll - 8.3.5
> build in Dev-cpp (mingw)
>
> PS. Function for int32( add_one(integer) ) is working
hm. I wonder if this is confusion between value/reference datums. Can
you do a quick check to see exactly where it's crashing (either before
you get into the function, at the getarg, or in the return)?
you can elog(WARNING, msg) to print out debug info from inside the function.
merlin
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
