Re: IMMUTABLE columns in tables?

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: IMMUTABLE columns in tables?
Date: 2010-06-15 19:46:37
Message-ID: AANLkTikrv6YZQe9yJvko4cymS8LN8fYCcoKVOBliPsY0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jun 15, 2010 at 11:54 AM, Chris Browne <cbbrowne(at)acm(dot)org> wrote:
> I'd like that feature, and I don't think it takes too much arguing to
> get to the point that a declarative "IMMUTABLE" control is rather less
>

Not only that, but if you were to, say, make the PK field IMMUTABLE
you could then optimize out the locks involved when updating rows with
FK relations to the PK (or any other FK field, I suppose)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bhaskar Sirohi 2010-06-15 19:48:10 Ideal Disk recommendation for PostgreSQL
Previous Message Oliver Kohll - Mailing Lists 2010-06-15 19:42:52 Backups / replication