Re: [HACKERS] Listen / Notify - what to do when the queue is full

2010-01-19 Thread Arnaud Betremieux
it to be able to use NOTIFY channel (SELECT col FROM table); instead of SELECT send_notify('channel', (SELECT col FROM table)); Best regards, Arnaud Betremieux On 19/01/2010 08:08, Jeff Davis wrote: Initial comments: * compiler warnings ipci.c: In function ‘CreateSharedMemoryAndSemaphores

Re: [HACKERS] Listen / Notify - what to do when the queue is full

2010-01-11 Thread Arnaud Betremieux
function on execution. Best regards, Arnaud Betremieux On 11/01/2010 07:58, Peter Eisentraut wrote: On mån, 2010-01-11 at 04:05 +, Greg Sabino Mullane wrote: On the one hand, I don't see the problem with ASCII here - the payload is meant as a quick shorthand convenience, not a literal

Re: [HACKERS] Listen / Notify - what to do when the queue is full

2010-01-11 Thread Arnaud Betremieux
On 11/01/2010 14:25, Tom Lane wrote: Arnaud Betremieuxarnaud.betremi...@keyconsulting.fr writes: 3) My use case : NOTIFY channel 'pay'||'load' (actually NOTIFY channel 'table_name#'||OLD.id) 4) Taken one step further : NOTIFY channel (SELECT payload FROM payloads WHERE ...)