Re: executing os commands from a function

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.

In response to

Browse pgsql-general by date

  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!