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.
