Re: executing os commands from a function
| От | Armand Pirvu (home) |
|---|---|
| Тема | Re: executing os commands from a function |
| Дата | |
| Msg-id | 38A3CDF9-A59B-433E-9C99-3B3C478008E7@gmail.com обсуждение исходный текст |
| Ответ на | Re: executing os commands from a function ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Список | pgsql-general |
Thanks for replies.
Good deal of info
While plsh seems to be an easier approach , I am also inclined in a an ESQL/C type app to listen to an event
@Igor Neyman
It is just maybe I have missed a sample of a C app in that area, similar like ESQLC
Cheers
Armand
On Sep 30, 2016, at 10:45 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
I used plsh extension but I had to use two functions and a trigger, see code belowI don't see any way to not use a trigger given your requirement. And as written I don't see that you need the second function - just write the trigger function in plsh. Admittedly its probably better to have two functions from an architecture standpoint.Listen/Notify doesn't seem to make sense as you want the server to ensure that the file exists - not some other client that may or may not be connected.David J.
В списке pgsql-general по дате отправления: