protecting a field after creation

From: Louis-David Mitterrand <cunctator(at)apartia(dot)ch>
To: pgsql-sql(at)postgresql(dot)org
Subject: protecting a field after creation
Date: 2000-08-20 16:29:33
Message-ID: 20000820182933.A2917@styx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

Is there a way (outside of RULEs and TRIGGERs) to make a field
read-only once it is INSERTed or assigned its default value? I'm
thinking, for example, of the "created" column that I add to most
tables, holding the row's creation timestamp.

Thanks in advance,

--
Louis-David Mitterrand - ldm(at)apartia(dot)org - http://www.apartia.org

Murphy's Guide to Science:
If it's green or squirms, it's biology.
If it stinks, it's chemistry.
If it doesn't work, it's physics.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-08-20 17:31:24 Re: protecting a field after creation
Previous Message Franz J Fortuny 2000-08-20 16:05:24 Speed or configuration