Re: ARCHIVE TABLES (was: possible TODO: read-only

From: Hannu Krosing <hannu(at)skype(dot)net>
To: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ARCHIVE TABLES (was: possible TODO: read-only
Date: 2005-05-03 10:12:33
Message-ID: 1115115153.4852.21.camel@fuji.krosing.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)skype(dot)net>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2005-05-03 10:46:18 Re: [pgsql-advocacy] Increased company involvement
Previous Message Hannu Krosing 2005-05-03 10:10:05 Re: ARCHIVE TABLES (was: possible TODO: read-only