How do I call multiple functions in one trigger? - Mailing list pgsql-general

From Wei Wang
Subject How do I call multiple functions in one trigger?
Date
Msg-id 016b01c3f4a9$abfa3de0$726ee880@weiwang
Whole thread Raw
Responses Re: How do I call multiple functions in one trigger?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

Can I call multiple functions in one trigger?
Something like this:

CREATE TRIGGER match_cond_name_generate
  BEFORE INSERT OR UPDATE
  ON public.predicate_index
  FOR EACH ROW
  EXECUTE PROCEDURE public.match_cond_name_generate();
  EXECUTE PROCEDURE public.create_predicate_table();


Postgresql won't allow me to do this. Multiple triggers won't guarantee the
order of the operations. Do I have to put everything into one single
function?


Many thanks,

Wei Wang


pgsql-general by date:

Previous
From: Ben
Date:
Subject: Re: making tsearch2 dictionaries
Next
From: Fischer Ulrich
Date:
Subject: Re: tsearch2: restoring problem