Hi
I am having troubles creating triggers using my functions ..
I have created the shared library with some functions which
appear to work in SELECT statement ..
But when I try to use those function in CREATE TRIGGER statement
it says that function doesn't exist ...
Any ideas ?
Thanks a lot
Yevgeny
I am using PostgresQL 7.2 on RedHat 7.3 ..
# load '/usr/local/lib/libtest.so';
LOAD
# create function more_than(integer,integer) returns integer
# as '/usr/local/lib/libtest.so','test' language c;
CREATE
# select more_than(4,6) as answer;
answer
--------
0
(1 row)
# select more_than(14,6) as answer;
answer
--------
1
(1 row)
# create trigger t_one
# after insert on t_table1 for each row
# execute procedure more_than(7, 4);
ERROR: CreateTrigger: function more_than() does not exist
#
