On Fri, 2020-05-15 at 08:09 +0800, Andy Fan wrote:
> On Thu, May 14, 2020 at 9:33 PM Laurenz Albe wrote:
> > On Thu, 2020-05-14 at 16:26 +0800, Andy Fan wrote:
> > > Thanks, actually I don't know how to use prepared transaction and how it
> > > works.
> > > I care about this because there is a l
On Thu, May 14, 2020 at 9:33 PM Laurenz Albe
wrote:
> On Thu, 2020-05-14 at 16:26 +0800, Andy Fan wrote:
> > Thanks, actually I don't know how to use prepared transaction and how
> it works.
> > I care about this because there is a long prepared transaction exists in
> our customer,
> > and we w
On Thu, 2020-05-14 at 16:26 +0800, Andy Fan wrote:
> Thanks, actually I don't know how to use prepared transaction and how it
> works.
> I care about this because there is a long prepared transaction exists in our
> customer,
> and we want to know what this transaction has doneļ¼like any data it
On Thu, May 14, 2020 at 4:05 PM Michael Paquier wrote:
> On Thu, May 14, 2020 at 03:38:24PM +0800, Andy Fan wrote:
> > I want to know what happens been done for an uncommitted prepared
> > transaction with pg_waldump, however I can't find it.
> >
> > demo=*# prepare transaction 's';
> > PREPARE T
On Thu, May 14, 2020 at 03:38:24PM +0800, Andy Fan wrote:
> I want to know what happens been done for an uncommitted prepared
> transaction with pg_waldump, however I can't find it.
>
> demo=*# prepare transaction 's';
> PREPARE TRANSACTION
> demo=# insert into mm select generate_series(1, 1000);
On Thu, May 14, 2020 at 3:38 PM Andy Fan wrote:
> I can get the log for "prepared command" only, but nothing was found for
> the insert
> statement. what should I do?
>
> My version is 9.4.
>
> Sorry, my production version is 9.4 and my demo above is v12. I tried in
9.4, I still have
trouble
Hi:
I want to know what happens been done for an uncommitted prepared
transaction with pg_waldump, however I can't find it.
demo=# begin;
BEGIN
demo=*# select txid_current();
txid_current
--
608
(1 row)
demo=*# prepare transaction 's';
PREPARE TRANSACTION
demo=# insert int
