Re: xlogdump enhancements - Mailing list pgsql-hackers

From Jonah H. Harris
Subject Re: xlogdump enhancements
Date
Msg-id 36e682920607140718p6c18ebd8m5e71bb96adf04b37@mail.gmail.com
Whole thread Raw
In response to Re: xlogdump enhancements  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: xlogdump enhancements  ("Diogo Biazus" <diogob@gmail.com>)
List pgsql-hackers
On 7/14/06, Martijn van Oosterhout <kleptog@svana.org> wrote:
> If you really want to tackle this the hard way, find some other program
> that does it. Here one written in Perl that can decode most tuples, but
> not all. It fails because it doesn't recognise all the types.

Yep Diogo, Martijn is correct.  You have to reassemble the tuple and
then generate the appropriate SQL statement for it.  For this, you'll
definitely need the catalog information to resolve relations, type
handling, etc.

-- 
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 2nd Floor            | jharris@enterprisedb.com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: xlogdump enhancements
Next
From: Bernd Helmle
Date:
Subject: Re: 8.2 features?