[HACKERS] NOTIFY in Background Worker

2015-08-28 Thread jacques klein
Hello, I added a NOFITY chan to the SQL arg of an SPI_execute(), (I did it also with just the NOTIFY statement), but the listeners (other workers) don't get the notification until a NOTIFY chan is done for example with pgadmin, They don't get lost, just not emited after the not forgotten call of

[HACKERS] how to write/setup a C trigger function in a background worker

2015-08-19 Thread jacques klein
I would like to execute a trigger function (written in C) in one of my background workers. Didn't figure out how to do that not even if it's possible. Currently my trigger function is called, but in the server-process connected to the client who does the insert into ... . Any hint/help is

Re: [HACKERS] how to write/setup a C trigger function in a background worker

2015-08-19 Thread jacques klein
at 10:01 -0700, David Fetter wrote: On Wed, Aug 19, 2015 at 05:37:31PM +0200, jacques klein wrote: I would like to execute a trigger function (written in C) in one of my background workers. Didn't figure out how to do that not even if it's possible. You can write your trigger function

Re: [HACKERS] how to write/setup a C trigger function in a background worker

2015-08-19 Thread jacques klein
-0400, Bill Moran wrote: On Wed, 19 Aug 2015 19:45:47 +0200 jacques klein jacques.k...@googlemail.com wrote: Well, sorry David, I don't understand what you mean, let me explain what I want to do: in short, IPC between background workers. I am trying to transform my app. from

[HACKERS] How to compile, link and use a C++ extension

2015-08-14 Thread jacques klein
Hello, I want to write a BackgroundWorker in C++ (have lots of C++ code and libs to reuse). I found35.9.13 Using C++ for Extensibility in the 9.3/4 documentation who says it's possible and gives some guidelines for source-code writing. Compiling is not too difficult if one understands