From: | Rohit Goyal <rhtgyl(dot)87(at)gmail(dot)com> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | pgsql novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Transaction Id and status of any operation |
Date: | 2013-11-20 15:22:24 |
Message-ID: | CANqGtSvjD-5eA4Z0DgX20iHsEh=F11i0w6AjBtOePrhSKPy75Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, Nov 20, 2013 at 12:51 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> On Tue, Nov 19, 2013 at 2:49 AM, Rohit Goyal <rhtgyl(dot)87(at)gmail(dot)com> wrote:
> > Hi All,
> >
> > I want to know the file or function from code which can give me the
> > transaction Id and its status. For example I want to find the details of
> > transaction currently inserting on some specific table.
> >
> > Also please tel me what function are called to check whether status of
> > transaction has changed. For example, I would like to get notified
> whenever
> > the status of any transaction changes. Please tel me the files or
> function
> > for this.
>
> Generally speaking, per MVCC rules, transactions can only see other
> transactions if they completed. It is up to the application to manage
> what to do when a transaction fails.
>
> There are internal C APIs (see: transam.c) to query transaction
> success through the clog system but I'm suspicious that this is the
> wrong line of thinking for you. Stepping back, what are you trying to
> do?
>
> merlin
>
Thanks for quick help !!!
I want to create an 2 array's which will store all each transaction Id and
also it current status in 2nd array. I also want status of transaction to
be update whenever any transaction change it status.
Regards,
Rohit Goyal
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2013-11-20 15:38:47 | Re: Transaction Id and status of any operation |
Previous Message | Rohit Goyal | 2013-11-20 15:11:43 | Re: B tree index || function information |