Re: making a trigger to a system call to a shell script

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Alejandro Fernandez <ale(at)e-group(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: making a trigger to a system call to a shell script
Date: 2002-05-02 21:45:18
Message-ID: 20020502144448.V52802-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2 May 2002, Alejandro Fernandez wrote:

> and now I've tried the following command as user postgres, in psql:
>
> create function alertme(char) returns int as '/home/ale/c/alertme.so' language 'C';
>
> and it says "stat failed on file '/home/ale/play/alertme.so': Permission denied"
>
> Permission? here are the file in question's permissions:
> -rwxrwxrwx
>
> That's more than's even safe... What am I doing wrong??

What about the directories it's in?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-05-02 21:46:13 Re: making a trigger to a system call to a shell script
Previous Message Grant Johnson 2002-05-02 21:44:01 Re: What popular, large commercial websites run