Re: [GENERAL] executing os commands from a function

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,

Re: [GENERAL] executing os commands from a function

On Thu, Sep 29, 2016 at 2:41 PM, Armand Pirvu (home) wrote: > I used plsh extension but I had to use two functions and a trigger, see > code below > ​I 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

Re: [GENERAL] executing os commands from a function

Armand On Thu, Sep 29, 2016 at 11:41 PM, Armand Pirvu (home) wrote: > I know this may sound like heresy since it involves executing an OS command > from a function , but here goes > After an insert in a table, I want to touch a file > I used plsh extension but I

Re: [GENERAL] executing os commands from a function

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Armand Pirvu (home) Sent: Thursday, September 29, 2016 5:42 PM To: pgsql-general@postgresql.org Subject: [GENERAL] executing os commands from a function All I know

[GENERAL] executing os commands from a function

All I know this may sound like heresy since it involves executing an OS command from a function , but here goes After an insert in a table, I want to touch a file I.e After insert into table test values (100) I want in a dir to have file 100 I used plsh extension but I had to use two