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