-Original Message-
From: Sergey Konoplev [mailto:gray...@gmail.com]
Sent: Thursday, December 06, 2012 4:52 PM
To: Igor Neyman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] unlooged tables
Hi,
On Thu, Dec 6, 2012 at 7:08 AM, Igor Neyman iney...@perceptron.com
wrote
On Fri, Dec 7, 2012 at 6:29 AM, Igor Neyman iney...@perceptron.com wrote:
-Original Message-
From: Sergey Konoplev [mailto:gray...@gmail.com]
Sent: Thursday, December 06, 2012 4:52 PM
To: Igor Neyman
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] unlooged tables
Hi
Hi,
On 2012-12-07 14:29:26 +, Igor Neyman wrote:
I was hoping, may be hacking pg_catalog, like setting pg_class.relpersistence
to 'u' will do the trick (or something like this).
b.t.w. there will be no other active connections, so there is no risk of
needing to add/update/delete
Hello,
Is there any way to change regular table to unlogged without dropping said
table and recreating it as unlogged?
Didn't find the answer in the docs. Looks like alter table ... does not
support unlogged.
TIA,
Igor Neyman
Hi,
On Thu, Dec 6, 2012 at 7:08 AM, Igor Neyman iney...@perceptron.com wrote:
Is there any way to change “regular” table to “unlogged” without dropping
said table and recreating it as unlogged?
AFAIK it is impossible currently.
The best way to do such transformation that comes to my mind is: