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)
Список
Дерево обсуждения
quit milis Tonny Sapri <tonnysapri@yahoo.co.id>
Re: quit milis Richard Huxton <dev@archonet.com>
disallow updates on column or whole table Peter Billen <peter@clueless.be>
Re: disallow updates on column or whole table Bill Moran <wmoran@collaborativefusion.com>
Re: quit milis Thomas Kellerer <spam_eater@gmx.net> 
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
Дата:
FAQ