Re: pg_rawdump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_rawdump
Date: 2010-10-19 22:53:51
Message-ID: 10783.1287528831@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Stephen R. van den Berg" <srb(at)cuci(dot)nl> writes:
> In order to simplify recovery at this point (enormously), it would
> have been very helpful (at almost negligible cost), to have the name
> of the table, the name of the columns, and the types of the
> columns available.

> Why don't we insert that data into the first page of a regular table
> file after in the special data area?

(1) it wouldn't necessarily fit

(2) what are you going to do to maintain it during ALTER TABLE?

(3) if there are any custom types involved, you're still lost.

regards, tom lane

In response to

  • pg_rawdump at 2010-10-19 20:12:23 from Stephen R. van den Berg

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-10-19 22:56:51 Re: patch: Add JSON datatype to PostgreSQL (GSoC, WIP)
Previous Message Tom Lane 2010-10-19 22:51:45 Re: patch: Add JSON datatype to PostgreSQL (GSoC, WIP)