Search Postgresql Archives

Incompatible library : Missing Magic Block

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 

Hi,

 

I am trying to code Postgres external C function in windows XP and am using Postgres 8.3 version.

However I have included all the required things in the code to run (Please find below the example code which I am compiling using MSVC and generating the dll)

 

_________________________________________________________________

// add.cpp : Defines the entry point for the DLL application.

//

 

#define _USE_32BIT_TIME_T

#include "postgres.h"

#include "fmgr.h"

//#ifdef PG_MODULE_MAGIC

PG_MODULE_MAGIC;

//#endif

 

PG_FUNCTION_INFO_V1(add_one);

Datum add_one(PG_FUNCTION_ARGS)

{

    int32   arg = PG_GETARG_INT32(0);

 

    PG_RETURN_INT32(arg + 1);

}

 _____________________________________________________________________

 

I could compile the code successfully and generate the dll with no errors but whenever I am compiling the below postgres functuion using the dll the it thrown an error saying

 

ERROR:  incompatible library "C:/Program Files/PostgreSQL/8.3/lib/add.dll": missing magic block

HINT:  Extension libraries are required to use the PG_MODULE_MAGIC macro.

 

Postgres Function

CREATE OR REPLACE FUNCTION add_one(IN int) RETURNS int AS '$libdir/add', 'add_one' LANGUAGE C;

 

Please provide your help at the earliest as this is really a show stopper for us.

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux