I'm trying to send a notification from the PG extension directly.
It turns out the mechanism that is used in the async file. (Async_Notify) does
not suit me since the function uses oldcontext = MemoryContextSwitchTo
(CurTransactionContext); and MemoryContextSwitchTo (oldcontext);
And I did not find the ability to add notification except the Async_Notify
function.
Now only SPI_execute works ("NOTIFY chanel,’message’", false, 0);
P.S. In my extension, there is already a higher function started with
oldcontext = MemoryContextSwitchTo (CurTransactionContext); and
MemoryContextSwitchTo (oldcontext);
>Пятница, 13 декабря 2019, 12:19 +03:00 от Pavel Stehule
><[email protected]>:
>
>Hi
>pá 13. 12. 2019 v 10:00 odesílatel Арсен Арутюнян < [email protected] > napsal:
>>Hello! I wrote my extension for PG and am trying to run Async_Notify from it.
>>But messages come very late! Sometimes only after I execute the notify
>>command from the shell. What am I doing wrong? How to use Async_Notify
>>correctly.
>>
>
>I am not sure what mechanism do you use.
>
>Notify messages are send after successful end of transaction.
>
>Regards
>
>Pavel
>
>>--
>>Арсен Арутюнян
--
Арсен Арутюнян
