On Thu, Mar 17, 2011 at 03:17:04PM -0700, aaronenabs wrote:
> well the project is about accessing the deleted rows not protected them. So
> what i would really like to achieve is to access data that i have removed
> from the database without the vacuum procedure carried out.
Well, presumably the code you'd need to look at lives in
src/backend/access/heap somewhere, or even just changing
the HeapTupleSatisfiesVisibility() macro in src/include/utils/tqual.h always
to return true. If you were to write your own app, after doing the above you'd
need to strip the heap access stuff out of postgres and build your app around
it. I think.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com