Re: IMMUTABLE columns in tables?

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: IMMUTABLE columns in tables?
Дата
Msg-id AANLkTikrv6YZQe9yJvko4cymS8LN8fYCcoKVOBliPsY0@mail.gmail.com
обсуждение исходный текст
Ответ на Re: IMMUTABLE columns in tables?  (Chris Browne <cbbrowne@acm.org>)
Список 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 по дате отправления:

Предыдущее
От: Oliver Kohll - Mailing Lists
Дата:
Сообщение: Backups / replication
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Inconsistency with LIKE and SIMILAR TO