disallow updates on column or whole table

Поиск
Список
Период
Сортировка
От Peter Billen
Тема disallow updates on column or whole table
Дата
Msg-id 493F9C41.6040108@clueless.be
обсуждение исходный текст
Ответ на Re: quit milis  (Richard Huxton <dev@archonet.com>)
Ответы Re: disallow updates on column or whole table  (Bill Moran <wmoran@collaborativefusion.com>)
Список pgsql-general
Hi all,

What is the best way to disallow updates on a column of a table, or even
on a whole table itself?

I can write a BEFORE UPDATE trigger which compares old.column_name(s) to
new.column_name(s) and raise an exception if these values are different.

Are there better ways?

Certain properties cannot be changed once inserted. I would like to
enforce that in my database schema.

Thanks in advance. Kind regards,

Peter

В списке pgsql-general по дате отправления:

Предыдущее
От: Maximilian Tyrtania
Дата:
Сообщение: tcp_keepalives_idle setting
Следующее
От: Erwin Moller
Дата:
Сообщение: noobquestion: How does Postgres delete 'smart' when deleting with FK contraints?