User-Defined functions

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
#

Responses

Browse pgsql-general by date

  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