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 re
On Fri, Dec 7, 2012 at 6:29 AM, Igor Neyman 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] un
> -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
Hi,
On Thu, Dec 6, 2012 at 7:08 AM, Igor Neyman 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:
CREATE TABLE table1
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
