Re: trigger help

Michael ,list

You are you are right, thanks a lot for your help and
tinme.
best regards
MDC

--- Michael Fuhr <mike(at)fuhr(dot)org> escribió:

> On Tue, Aug 22, 2006 at 02:37:19PM -0300, marcelo
> Cortez wrote:
> > > This isn't a trigger function. Are you sure
> "trigger" is the
> > > word you meant?
> >
> > yes i do
>
> I see: the function you originally posted is called
> by a trigger
> function. In any case the answer is the same:
> functions can't start
> or end transactions because they're already being
> executed in the
> context of an outer transaction. My previous
> message mentioned
> using dblink as a way around that, but that's not
> necessarily good
> design -- one problem is that if the outer
> transaction rolls back
> then transactions that have already been committed
> over a dblink
> connection won't be rolled back. Doing transaction
> control from
> outside the functions would probably be better.
>
> --
> Michael Fuhr
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

__________________________________________________
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yahoo.com.ar/respuestas