From: | Jenia <jenia(dot)k(at)ntlworld(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | User-Defined functions |
Date: | 2002-09-03 08:22:07 |
Message-ID: | 200209030922.07372.jenia.k@ntlworld.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
#
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick FICHE | 2002-09-03 08:53:16 | Porting SQL Server -> PostgreSQL ( SELECT INTO problem... ) |
Previous Message | Ben-Nes Michael | 2002-09-03 08:11:57 | Re: php |