problem creating triggers and stored procedures

Started by John P. Looneyover 24 years ago1 messagesgeneral
Jump to latest
#1John P. Looney
john@antefacto.com

I'm trying to work out how to get triggers working, using the example
"add_one(int4)" C function given in the programmers guide;

postgres=# select add_one(-2.4) as stuff;
stuff
-------
-1
(1 row)

... so, it works fine. However, I can't create a trigger, using that
stored procedure;

postgres=# create trigger add_one_to_col_one AFTER INSERT on test_table for each row execute procedure add_one();
ERROR: CreateTrigger: function add_one() does not exist

Any idea why this would be ? Also, I created a user, and tryed to execute
the add_one() stored procedure. It seems normal users don't have access to
them. The following returns "add_one" when run as postgres, but not when
run as a normal user. Can this behaviour be altered ?

select proname from pg_proc where proname = 'add_one';

John

--
_______________________________________
John Looney Chief Scientist
a n t e f a c t o t: +353 1 8586004
www.antefacto.com f: +353 1 8586014