David Blasby wrote:
Sebastien Lemieux wrote:
Hi,
I need to extend postgreSQL to support some specific function I
will code in C (ideally C++ if it can work!).
Be very carefull with using C++ functions inside postgresql. If the
C++ code throws an exception the postgresql backend will get a SIGABRT
and terminate.
You can solve this by linking the std c++ library to the postmaster.
We tried everything we could think of to fix this, but this was the
only solution that worked.
For a complete discussion, you can read the PostGIS (GIS spatial
objects for Postgresql) mailing list (http://postgis.refractions.net)
and the GEOS (Geometry Engine, Open Source) mailing list
(http://geos.refractions.net).
If you try C++, you will find some nasty name/reserved words collisions,
but it will work:
#define using __using
#define typeid __typeid
#define typename __typename
#define namespace __namespace
#define delete __delete
extern "C"
{
#include "postgres.h"
#include "executor/spi.h"
#include "funcapi.h"
}
#undef using
#undef typeid
#undef typename
#undef namespace
#undef delete
Fortunately, my code didn't use exceptions...
Regards,
Andreas
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
