| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)pl> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | how do i create trigger with params? |
| Date: | 2001-03-10 16:23:40 |
| Message-ID: | 20010310172340.A2190@depeszws.depesz.pl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
i would like to create c-type trigger which is used with params.
so i created function:
CREATE function dfti(text) RETURNS opaque as
'/home/users/pgdba/work/lib/dfti.so' language 'C';
o.k. created
byt when i try to:
CREATE trigger dfti_trg after INSERT or UPDATE or DELETE on newstexts for each
row execute procedure dfti ('newstexts');
i get:
psql:create.sql:9: ERROR: CreateTrigger: function dfti() does not exist
which is of course true. function dfti() doesn't exist, but i wanted to use
dfti(text)!
if i change function creation not to have (text) trigger is properly created,
but it fails (killing backend) on insert.
what did i wrong?
depesz
--
hubert depesz lubaczewski http://www.depesz.pl/
------------------------------------------------------------------------
najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
jest niesamowita wręcz łatwość unikania kontaktów z nim ...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Marschalek | 2001-03-10 17:58:28 | Money... |
| Previous Message | Poul L. Christiansen | 2001-03-10 16:08:39 | Re: Memory requirments |