pg_dirtyread 1.2 released

pg_dirtyread
------------

The pg_dirtyread extension provides the ability to read dead but
unvacuumed rows from a relation. All PostgreSQL versions including 10
and 11devel as of now are supported.

Compared to the original pg_dirtyread 1.0 version from 2012 (written
by Phil Sorber while at OmiTI), version 1.2 adds the ability to
retrieve system columns such as xmax and ctid:

SELECT * FROM pg_dirtyread('foo'::regclass)
    AS t(tableoid oid, ctid tid, xmin xid, xmax xid, cmin cid, cmax cid, dead boolean,
         oid oid, bar bigint, baz text);
 tableoid │ ctid  │ xmin │ xmax │ cmin │ cmax │ dead │ oid │ bar │        baz
──────────┼───────┼──────┼──────┼──────┼──────┼──────┼─────┼─────┼───────────────────
    41823 │ (0,1) │ 1484 │ 1485 │    0 │    0 │ t    │   0 │   1 │ Delete
    41823 │ (0,2) │ 1484 │    0 │    0 │    0 │ f    │   0 │   2 │ Insert
    41823 │ (0,3) │ 1484 │ 1486 │    0 │    0 │ t    │   0 │   3 │ Update
    41823 │ (0,4) │ 1484 │ 1488 │    0 │    0 │ f    │   0 │   4 │ Not deleted
    41823 │ (0,5) │ 1484 │ 1489 │    1 │    1 │ f    │   0 │   5 │ Not updated
    41823 │ (0,6) │ 1486 │    0 │    0 │    0 │ f    │   0 │   3 │ Updated
    41823 │ (0,7) │ 1489 │    0 │    1 │    1 │ t    │   0 │   5 │ Not quite updated
    41823 │ (0,8) │ 1490 │    0 │    2 │    2 │ t    │   0 │   6 │ Not inserted

Download
--------

https://github.com/ChristophBerg/pg_dirtyread

Packages for Debian and Ubuntu are available from apt.postgresql.org.

-- 
Senior Berater, Tel.: +49 2166 9901 187
credativ GmbH, HRB Mönchengladbach 12080, USt-ID-Nummer: DE204566209
Trompeterallee 108, 41189 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer
pgp fingerprint: 5C48 FE61 57F4 9179 5970  87C6 4C5A 6BAB 12D2 A7AE


-- 
Sent via pgsql-announce mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-announce