Re: Accessing dead rows within postgresql - Mailing list pgsql-novice

From Joshua Tolley
Subject Re: Accessing dead rows within postgresql
Date
Msg-id 4d83c14c.04558f0a.114a.ffffb9ca@mx.google.com
Whole thread Raw
In response to Re: Accessing dead rows within postgresql  (aaronenabs <aaronenabs@btconnect.com>)
Responses Re: Accessing dead rows within postgresql  (aaronenabs <aaronenabs@btconnect.com>)
List pgsql-novice
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

Attachment

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql iPhone
Next
From: Dimitri
Date:
Subject: Return only unique id's that are not associated with value