Re: making a trigger to a system call to a shell script - Mailing list pgsql-general

From Stephan Szabo
Subject Re: making a trigger to a system call to a shell script
Date
Msg-id 20020502144448.V52802-100000@megazone23.bigpanda.com
Whole thread Raw
In response to making a trigger to a system call to a shell script  (Alejandro Fernandez <ale@e-group.org>)
List 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?


pgsql-general by date:

Previous
From: Grant Johnson
Date:
Subject: Re: What popular, large commercial websites run
Next
From: Tom Lane
Date:
Subject: Re: making a trigger to a system call to a shell script