| From: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
|---|---|
| To: | "Martijn van Oosterhout" <kleptog(at)svana(dot)org> |
| Cc: | "Diogo Biazus" <diogob(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: xlogdump enhancements |
| Date: | 2006-07-14 14:18:44 |
| Message-ID: | 36e682920607140718p6c18ebd8m5e71bb96adf04b37@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 7/14/06, Martijn van Oosterhout <kleptog(at)svana(dot)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(at)enterprisedb(dot)com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bernd Helmle | 2006-07-14 14:26:40 | Re: 8.2 features? |
| Previous Message | Martijn van Oosterhout | 2006-07-14 14:02:52 | Re: xlogdump enhancements |