On Thu, 2 Feb 2006, Tony Caduto wrote: > Tom Lane wrote: > > >Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx> writes: > > > > > >>I saw some where that if I recompiled my server with > >>MAKE_EXPIRED_TUPLES_VISIBLE I would be able to see deleted rows? > >> > >> > > > >If you aren't a certified wizard you do NOT want to turn that on, > >because it will very probably help you make things worse. My opinion > >on it is on record: > >http://archives.postgresql.org/pgsql-patches/2005-02/msg00126.php > > > Well, it does not seem to do anything, I enabled it with ./configure > --enable-MAKE_EXPIRED_TUPLES_VISIBLE > I then thought well maybe I need to do dump of the table and the deleted > tuples would be in there, but no. > > ./configure --enable-MAKE_EXPIRED_TUPLES_VISIBLE is the correct way to > enable it right? I think something like CFLAGS="-D MAKE_EXPIRED_TUPLES_VISIBLE" ./configure would be the way to get it.
