>On Wed, May 28, 2008 at 8:30 PM, Mike <[EMAIL PROTECTED]> wrote: >> When you say a bit of decoding, is that because the data written to the logs >> is after the query parser/planner? Or because it's written in several >> chunks? Or? > >Because that's the actual recovery record. There is no SQL text, just >the WAL record type (XLOG_HEAP_INSERT, XLOG_HEAP_UPDATE, >XLOG_XACT_COMMIT, ...) and the data as it relates to that operation.
Hmm... after looking at the xlogdump and xlogview applications, I can see the difficulty pulling this information you were talking about. I see that I can get the OID's for the relations, and then lookup their names from the source database; but pulling where clause and field info seems to be a bit tougher. Is there another place in the code, I can get access to the statements (or statement "like" information), after a transaction commit? Thanks for all your help, Mike -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers