"Constant" fields in a table

From: Adrian von Bidder <avbidder(at)fortytwo(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: "Constant" fields in a table
Date: 2007-06-15 08:24:26
Message-ID: 200706151024.26737.avbidder@fortytwo.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-06-15 08:32:38 Re: "Constant" fields in a table
Previous Message Adrian von Bidder 2007-06-15 08:20:32 Q: Tree traversal with SQL query?