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.
BEGIN:VCARD
VERSION:2.1
N:Taylor;Rod;B
FN:Taylor, Rod B
ORG:BarChord Entertainment Inc.;System Operation and Development
TITLE:Chief Technical Officer
ADR;WORK:;;;Toronto;Ontario;;Canada
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Toronto, Ontario=0D=0ACanada
X-WAB-GENDER:2
URL:
URL:http://www.barchord.com
BDAY:19790401
EMAIL;INTERNET:[EMAIL PROTECTED]
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
EMAIL;INTERNET:[EMAIL PROTECTED]
REV:20010213T153525Z
END:VCARD
