Re: IMMUTABLE columns in tables? - Mailing list pgsql-general

From Vick Khera
Subject Re: IMMUTABLE columns in tables?
Date
Msg-id AANLkTikrv6YZQe9yJvko4cymS8LN8fYCcoKVOBliPsY0@mail.gmail.com
Whole thread Raw
In response to Re: IMMUTABLE columns in tables?  (Chris Browne <cbbrowne@acm.org>)
List pgsql-general
On Tue, Jun 15, 2010 at 11:54 AM, Chris Browne <cbbrowne@acm.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)

pgsql-general by date:

Previous
From: Oliver Kohll - Mailing Lists
Date:
Subject: Backups / replication
Next
From: Bruce Momjian
Date:
Subject: Re: Inconsistency with LIKE and SIMILAR TO