At Wed, 25 May 2022 11:01:43 -0400, Fred Habash wrote in
> I'm running this command while connected to pg cluster DB1:
>
> SELECT * FROM pg_create_logical_replication_slot('test_slot_99',
> 'test_decoding');
>
> When I examine pg_locks, I see the session is waiting on virtualxid and
> blocked a
"David G. Johnston" writes:
> On Thursday, May 26, 2022, Matthias Apitz wrote:
>> Is there any way to get with the old CTID to the row, for example with
>> the old CTID to the new one which the row now has after the update of the
>> row?
> No, there is no link between old and new in the main tab
On Thursday, May 26, 2022, Matthias Apitz wrote:
>
> Is there any way to get with the old CTID to the row, for example with
> the old CTID to the new one which the row now has after the update of the
> row?
>
>
No, there is no link between old and new in the main table.
David J.
El día Wednesday, May 25, 2022 a las 11:21:44AM +0200, Matthias Apitz escribió:
> El día martes, mayo 24, 2022 a las 12:11:49 -0400, Tom Lane escribió:
>
> > Laurenz Albe writes:
> > > It may well be that somebody deleted or updated a few rows between the
> > > time
> > > the cursor was materia
