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

2015-08-19 Thread jacques klein
Ok, think I got it, I can use LISTEN and NOTIFY to do my IPC stuf, will just have to see if it's possible to listen in a worker, with a permanent server connection, I guess. (as I remember, I already did a "listener" 10 years ago in a C client app.) Thanks, Jaquest K. On Wed, 2015-08-19 at 16:5

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

2015-08-19 Thread Alvaro Herrera
Bill Moran wrote: > On Wed, 19 Aug 2015 19:45:47 +0200 > jacques klein 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 a multi-threaded C SQL

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

2015-08-19 Thread Bill Moran
On Wed, 19 Aug 2015 19:45:47 +0200 jacques klein 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 a multi-threaded C SQL-client into > some "background work

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

2015-08-19 Thread jacques klein
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 a multi-threaded C SQL-client into some "background workers", execution speed beeing the goal (avoid network io). Worker start/s

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

2015-08-19 Thread David Fetter
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 in such a way as not to do the usual ch

[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 we