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 CAFj8pRD5zoA=6PqSncPJ2+sckFOvH5yJAWw-r4ow893V1070Ew@mail.gmail.com
Whole thread Raw
In response to Re: Autonomous Transaction (WIP)  (Rajeev rastogi <rajeev.rastogi@huawei.com>)
Responses Re: Autonomous Transaction (WIP)  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view
Hello

regress tests fails:

     plancache                ... ok
     limit                    ... ok
     plpgsql                  ... ok
     copy2                    ... ok
     temp                     ... FAILED
     domain                   ... ok
     rangefuncs               ... ok
     prepare                  ... ok
     without_oid              ... ok
     conversion               ... ok
     truncate                 ... ok
     alter_table              ... ok
     sequence                 ... ok

I did some small tests and it works well. When I looked to code, I was surprised by hardcoded max nesting level of autonomous transactions

#define     MAX_AUTOX_NESTING_LEVEL   3

why? Is not it too restrictive?

I am missing a regress tests.

Regards

Pavel






2014-06-18 11:19 GMT+02:00 Rajeev rastogi <rajeev.rastogi@huawei.com>:
On 17 June 2014 02:01, Alvaro Herrera Wrote:

> What's the status of this patch?

I have completed work on this and some more changes are done on top of earlier patch shared:
1. Fixed all of the issues observed.
2. Addressed some of the feedback from community like
        a. Change the syntax to
                        START AUTONOMOUS TRANSACTION [READ ONLY | READ WRITE]
        b. As Pavan had pointed, I have made transaction behavior (only read-only properties) of main and autonomous transaction independent.
3. Added documentation for this feature.
4. Rebased to latest git code.

Please find the attached latest patch and provide opinion.

Thanks and Regards,
Kumar Rajeev Rastogi



--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Attachment

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: API change advice: Passing plan invalidation info from the rewriter into the planner?
Next
From: Pavel Stehule
Date:
Subject: Re: Autonomous Transaction (WIP)