Re: trigger help - Mailing list pgsql-general

From marcelo Cortez
Subject Re: trigger help
Date
Msg-id 20060823105145.59863.qmail@web32101.mail.mud.yahoo.com
Whole thread Raw
In response to Re: trigger help  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Michael ,list

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

 --- Michael Fuhr <mike@fuhr.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


pgsql-general by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: [JDBC] org.postgresql.util.PSQLException: An I/O error occured
Next
From: Roman Neuhauser
Date:
Subject: Re: UUID as primary key