Re: Extending PostgreSQL in C or C++

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