pg_prepared_xacts returns transactions that are foreign to the caller - Mailing list pgsql-hackers

From Vladimir Sitnikov
Subject pg_prepared_xacts returns transactions that are foreign to the caller
Date
Msg-id CAB=Je-FN4u6Xb8D3eY7qWAbfhEvM-8fpWb-cLKJuxVC=5tMFtA@mail.gmail.com
Whole thread Raw
Responses Re: pg_prepared_xacts returns transactions that are foreign to the caller
List pgsql-hackers
Hi,

"select * from pg_prepared_xacts" might produce transactions created by a different user, so the caller won't be able to issue "commit prepared".

I think there should be a view that returns only the transactions that the caller can commit or rollback.
Is it something that can be implemented at the backend?

Currently, the backend checks owner and database when user calls "commit prepared", so I believe the similar filter should be implemented in pg_prepared_xacts view:

Vladimir

pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: Support LIKE with nondeterministic collations
Next
From: Corey Huinker
Date:
Subject: Re: PGSERVICEFILE as part of a normal connection string