Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger question - Mailing list pgsql-general

From Nelio Alves Pereira Filho
Subject Re: Trigger question
Date
Msg-id 3A22A13B.46E32AF7@ifx.com.br
Whole thread Raw
In response to Trigger question  (Nelio Alves Pereira Filho <nelio@ifx.com.br>)
List pgsql-general
Tree view 
> > these values, and the AFTER trigger to do this calculation.
>
> Why don't you just do all the work in the BEFORE trigger?

For instance, If I do an UPDATE inside a function that will be triggered
by an UPDATE, won't it loop forever?

Does PostgreSQL support recursive functions?

Thanks

pgsql-general by date:

Previous
From: mkennedy@hssinc.com (Matthew Kennedy)
Date:
Subject: strange behaviour
Next
From: Tom Lane
Date:
Subject: Re: How to keep Postgres from thrashing for a long time using "LIMIT" (or is there a better way?)!