Postgres Pro
Downloads
Home   >   mailing lists

Re: ARCHIVE TABLES (was: possible TODO: read-only - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: ARCHIVE TABLES (was: possible TODO: read-only
Date
Msg-id 1115115153.4852.21.camel@fuji.krosing.net
Whole thread Raw
In response to Re: ARCHIVE TABLES (was: possible TODO: read-only tables, select from indexes only.)  ("Jim C. Nasby" <decibel@decibel.org>)
List pgsql-hackers
Tree view 
On E, 2005-05-02 at 15:59 -0500, Jim C. Nasby wrote:
> Out of curiosity, what would be required to allow deletes (but not
> updates)?

Perhaps a "CLUSTER indexname ON tablename WHERE xxx" could be used for
that. 

That is a CLUSTER command that leaves out the tuples which do not
satisfy "xxx".

-- 
Hannu Krosing <hannu@skype.net>

pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: ARCHIVE TABLES (was: possible TODO: read-only
Next
From: Peter Eisentraut
Date:
Subject: Re: [pgsql-advocacy] Increased company involvement