{"repo":"df7cb/pg_dirtyread","free":true,"listed":false,"github":"https://github.com/df7cb/pg_dirtyread","clone":"git clone https://github.com/df7cb/pg_dirtyread.git","description":"Read dead but unvacuumed tuples from a PostgreSQL relation","language":"C","stars":165,"topics":["pg-dirtyread","postgresql","extension","uncommitted"],"license":null,"category":"databases-storage","readme_excerpt":"pg dirtyread ============ The pg dirtyread extension provides the ability to read dead but unvacuumed rows from a relation. Supports PostgreSQL 9.2 and later. (On 9.2, at least 9.2.9 is required.) Building -------- To build pg dirtyread, just do this: make make install If you encounter an error such as: make: pg config: Command not found Be sure that you have pg config installed and in your path. If you used a package management system such as RPM to install PostgreSQL, be sure that the -devel package is also installed. If necessary tell the build process where to find it: make PG CONFIG=/path/to/pg config make install PG CONFIG=/path/to/pg config Loading and Using ------- Once pg dirtyread is built and installed, you can add it to a database. Loading pg dirtyread is as simple as connecting to a database as a super user and running: The pg dirtyread() function returns RECORD, therefore it is necessary to attach a table alias clause that describes the table schema. Columns are matched by name, so it is possible to omit some columns in the alias, or rearrange columns. Example: Dropped Columns --------------- The content of dropped columns can be retrieved as long as the table has not been rewritten (e.g. via VACUUM FULL or CLUSTER ). Use dropped N to access the Nth column, counting from 1. PostgreSQL deletes the type information of the original column, so only a few sanity checks can be done if the correct type was specified in the table alias; checked are type length, type ali","default_branch":null,"files":null,"tree":[],"storefront":"/r/df7cb","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/df7cb/pg_dirtyread/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}