FW: Incompatible library : Missing Magic Block

From: <A(dot)Bhattacharya(at)sungard(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: FW: Incompatible library : Missing Magic Block
Date: 2009-10-22 06:19:57
Message-ID: 4AD2336877609F41A2B0D53BAD09FC579D71C8@VOO-EXCHANGE07.internal.sungard.corp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

One more thing to add here...I am using the Postgres 8.3.7 headers to
compile my program and have added PG_MODULE_MAGIC but still error is
persisting.

________________________________

From: Bhattacharya, A
Sent: Thursday, October 22, 2009 10:46 AM
To: 'pgsql-general(at)postgresql(dot)org'
Subject: Incompatible library : Missing Magic Block

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.

Browse pgsql-general by date

  From Date Subject
Next Message Mike Christensen 2009-10-22 10:13:51 Design question about partitioning order information across tables
Previous Message John R Pierce 2009-10-22 05:27:17 Re: Preventing database listing?