Re: C Trigger issue
От | Rod Taylor |
---|---|
Тема | Re: C Trigger issue |
Дата | |
Msg-id | 0c4601c095db$49867960$6500000a@jester обсуждение исходный текст |
Ответ на | C Trigger issue ("Rod Taylor" <rod.taylor@inquent.com>) |
Ответы |
Re: C Trigger issue
|
Список | pgsql-hackers |
Sorry, Postgres 7.1 beta4 -- Rod Taylor There are always four sides to every story: your side, their side, the truth, and what really happened. ----- Original Message ----- From: "Rod Taylor" <rod.taylor@inquent.com> To: "Hackers List" <pgsql-hackers@postgresql.org> Sent: Tuesday, February 13, 2001 10:35 AM Subject: [HACKERS] 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. >
В списке pgsql-hackers по дате отправления: