"Constant" fields in a table

Поиск
Список
Период
Сортировка
От Adrian von Bidder
Тема "Constant" fields in a table
Дата
Msg-id 200706151024.26737.avbidder@fortytwo.ch
обсуждение исходный текст
Ответы Re: "Constant" fields in a table  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-general
Hi,

I want to tighten down my db schema as much as possible against accidential
corruption.  For this, I'd like to have fields that can only inserted and
not later changed (think some sort of "id", account names, etc., which are
often not only stored in the database but also in external places so
changing is just a definitive DON'T).

Obviously I can check this with triggers, but it occured me that some kind
of "CONSTANT" field attribute would be nice.  Perhaps such a construct
already exists?  Or perhaps somebody has come up with a generic way to do
this without having to write 30 or 50 small triggers all over the place?

thanks in advance
cheers
-- vbi

(I read the list, but will be away on holidays later today, so don't worry
if you don't hear back from me.  Your input is appreciated.)

--
Could this mail be a fake? (Answer: No! - http://fortytwo.ch/gpg/intro)

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

Предыдущее
От: Adrian von Bidder
Дата:
Сообщение: Q: Tree traversal with SQL query?
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: "Constant" fields in a table