View Single Post

   
  #4 (permalink)  
Old 04-15-2008, 11:42 PM
Pavel Stehule
 
Posts: n/a
Default Re: autonomous transactions

>
> Agreed. I think Pavel Stehule was doing some experiments with them, I
> don't know if he got anywhere.
>


I did only first research. Any hack is possible - you can stack
current transaction, but real implementation needs similar work like
nested transaction and it is too low level for me. And some code
cleaning is necessary. There are global variables.

And there is most important question about data visibility - is
autonomous transaction independent on main transaction (isolation)?
You have to thing about deadlock, about reference integrity, etc. This
task isn't simple.

Pavel



> --
> Alvaro Herrera http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply With Quote