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 into mm select generate_series(1, 1000);
INSERT 0 1000
demo=#
BEGIN
demo=*# select txid_current();
txid_current
--------------
608
(1 row)
demo=*# prepare transaction 's';
PREPARE TRANSACTION
demo=# insert into mm select generate_series(1, 1000);
INSERT 0 1000
demo=#
===
pg_wal> ~/postgres/bin/pg_waldump 00000001000000000000008F | grep 'tx: 608'
rmgr: Transaction len (rec/tot): 138/ 138, tx: 608, lsn: 0/8F68C020, prev 0/8F68BFD0, desc: PREPARE gid s: 2020-05-14 15:00:33.212997 CST
rmgr: Transaction len (rec/tot): 138/ 138, tx: 608, lsn: 0/8F68C020, prev 0/8F68BFD0, desc: PREPARE gid s: 2020-05-14 15:00:33.212997 CST
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.
Thanks