C Trigger issue

Create function, attempt to create trigger fails, yet function
obviously exists.  I can't seem to typecast the trigger parameters.
\df even misses the function.



temp=# CREATE FUNCTION dbuser_account(varchar(40), varchar(40),
varchar(40))

temp-# RETURNS OPAQUE

temp-# AS
'/usr/home/rbt/temp/postgresql-7.1beta4/contrib/user_account/user_acco
unt.so'

temp-# language 'C';

CREATE

temp=#

temp=# \df dbuser_account

List of functions

Result | Function | Arguments

--------+----------+-----------

(0 rows)

temp=#

temp=# select dbuser_account('test', 'test', 'test');

ERROR: dbuser_account: not fired by trigger manager

temp=#

temp=#

temp=# CREATE TRIGGER dbuser_account_trg

temp-# AFTER INSERT

temp-# OR DELETE

temp-# OR UPDATE

temp-# ON users

temp-# FOR EACH row

temp-# EXECUTE PROCEDURE dbuser_account('val1', 'val2', 'val3');

ERROR: CreateTrigger: function dbuser_account() does not exist

temp=#

temp=# DROP FUNCTION dbuser_account(varchar(40), varchar(40),
varchar(40));

DROP

--
Rod Taylor

There are always four sides to every story: your side, their side, the
truth, and what really happened.