Re: making an unlogged table logged

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: making an unlogged table logged
Date: 2011-01-08 14:44:11
Message-ID: AANLkTim_8UerzSr3FQLsy2Trs-DmP+Q2h3ymSVbsRDKt@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jan 4, 2011 at 9:41 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> Generally, to do this, it would be necessary to do the following
> things (plus anything I'm forgetting):

It occurs to me that almost exactly this same procedure could be used
to make a *temporary* table into a permanent table. You'd have to
also change the schema, and there'd be some other adjustments, but
overall it'd be pretty similar.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2011-01-08 14:52:41 Error code for "terminating connection due to conflict with recovery"
Previous Message Magnus Hagander 2011-01-08 14:22:12 Re: obj_unique_identifier(oid)