Horton
Menu

Re: pg_prepared_xacts returns transactions that are foreign to the caller

Andrey Borodin <x4mmm@yandex-team.ru>

View thread
From: "Andrey M. Borodin" <x4mmm@yandex-team.ru>
To: Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
Cc: Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2024-11-20T09:07:48Z
Lists: pgsql-hackers 

> On 20 Nov 2024, at 12:48, Vladimir Sitnikov <sitnikov.vladimir@gmail.com> wrote:
> 
> "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?

Like "select * from pg_prepared_xacts where pg_has_role(current_user, owner, 'member');"?


Best regards, Andrey Borodin.

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. doc: Fix section of functions age(xid) and mxid_age(xid)