Thanks for the suggestions. I put it in /usr/lib/pgsql and now it's getting taken. I used the command
create function alertme(varchar(100)) returns int as '/usr/lib/pgsql/alertme.so' language 'C';
This seemed to work: it returned "CREATE"
Then commands like:
select alertme('This is not an exercise!');
would send me an email, although there seems to be a problem with the types, because it takes a char * as an argument,
butI couldn't find a list of types for postgresql functions, so the email it sends always contains one symbol (pi for
stringsand 3/4ths symbol for integers or chars), can't cut and paste it to show...).
Anyway, last step was to create a trigger so that I could monitor changes to my table remotely:
create trigger trigger_alertme
before insert or update on mytable for each row execute procedure alertme('blablabla');
And this will not work: it returns:
ERROR: CreateTrigger: function alertme() does not exist
Any idea where to go from here?
Thanks again! - I think this is quite a frequent wish by many people, as I've seen the question "how do I trigger an
outsidescript" crop up unanswered quite a few times in the archives. I did get the email about the sourceforge project
-thanks a lot! - but I'm so far into this, I'd like to get to the bottom of it first! (Yes, and meanwhile I'm using
cron- thanks!).
Ale
On Thu, 02 May 2002 17:46:13 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Alejandro Fernandez <ale@e-group.org> writes:
> > and it says "stat failed on file '/home/ale/play/alertme.so': Permission denied"
>
> > Permission? here are the file in question's permissions:
> > -rwxrwxrwx
>
> How about permissions on the directories in the path?
>
> regards, tom lane
--
Alejandro Fernandez
Electronic Group Interactive
--+34-65-232-8086--