Postgres Pro
Downloads
Home   >   mailing lists

Re: Autonomous Transaction (WIP) - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Autonomous Transaction (WIP)
Date
Msg-id CAFj8pRA8WCgTFVtHT1X1nLbCurX0-PqwrZxfrvVwMRni1rKJDA@mail.gmail.com
Whole thread Raw
In response to Re: Autonomous Transaction (WIP)  (Rajeev rastogi <rajeev.rastogi@huawei.com>)
Responses Re: Autonomous Transaction (WIP)  (Atri Sharma <atri.jiit@gmail.com>)
List pgsql-hackers
Tree view



2014-04-07 11:59 GMT+02:00 Rajeev rastogi <rajeev.rastogi@huawei.com>:

On 07 April 2014 12:12, Pavel Stehule wrote:

>+1 for feature

Thanks

 

>-1 for Oracle syntax - it is hardly inconsistent with Postgres

We can discuss and come out with the syntax based on everyone agreement.

>Autonomous transactions should be used everywhere - not only in plpgsql

 

Yes you are right. I am not planning to support only using plpgsql.  Initially we can support this

Using the standalone SQL-commands and then later we can enhance based on this infrastructure

to be used using plpgsql, triggers.


ok

long time I though about this feature.

I am thinking so this should be fully isolated transaction - it should not be subtransaction, because then you can break database consistency - RI

I am happy so someone does this job

Regards

Pavel
 

 

Thanks and Regards,

Kumar Rajeev Rastogi

 


pgsql-hackers by date:

Previous
From: Rajeev rastogi
Date:
Subject: Re: Autonomous Transaction (WIP)
Next
From: Atri Sharma
Date:
Subject: Re: Autonomous Transaction (WIP)