> On 20 Nov 2024, at 12:48, Vladimir Sitnikov <sitnikov.vladi...@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.
