From: | "Armand Pirvu (home)" <armand(dot)pirvu(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: executing os commands from a function |
Date: | 2016-10-01 01:36:36 |
Message-ID: | 38A3CDF9-A59B-433E-9C99-3B3C478008E7@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Thu, Sep 29, 2016 at 2:41 PM, Armand Pirvu (home) <armand(dot)pirvu(at)gmail(dot)com> 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 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.
From | Date | Subject | |
---|---|---|---|
Next Message | PHANIKUMAR G | 2016-10-01 15:30:06 | Re: postgres failed to start from services manager on windows 2008 r2 |
Previous Message | Adrian Klaver | 2016-10-01 00:43:07 | Re: [ANNOUNCE] pgAdmin 4 v1.0 Released! |