Search Postgresql Archives

Check what has been done for a uncommitted prepared transaction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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=#

===


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

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux