Re: preserving forensic information when we freeze - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: preserving forensic information when we freeze
Date
Msg-id 20131220022202.GO11006@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: preserving forensic information when we freeze  (Jim Nasby <jim@nasby.net>)
Responses Re: preserving forensic information when we freeze
List pgsql-hackers
Jim Nasby escribió:
> One thing users will lose in this patch is the ability to reliably see if a tuple is frozen via SQL. Today you can do
thatjust by selecting xmin from the table.
 
> 
> Obviously people don't generally need to do that... but it's one of those things that when you do need it it's
incrediblyhandy to have... would it be difficult to expose infomask(2) via SQL, the same way xmin et all are?
 

It's already exposed via the pageinspect extension.  It's doubtful that
there are many valid cases where you need infomask but don't have access
to that module.

The real fix seems to ensure that the module is always available.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Gregory Smith
Date:
Subject: Re: row security roadmap proposal
Next
From: Noah Misch
Date:
Subject: Re: [bug fix] multibyte messages are displayed incorrectly on the client