Read-only column

From: Claudio Succa <claudio(dot)succa(dot)ml(at)pertel(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Read-only column
Date: 2003-12-12 18:59:58
Message-ID: 1071255598.1552.35.camel@master.to1.pertel.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Given a table like the following:

CREATE TABLE mytable (
progr integer PRIMARY KEY,
record_creation_date date DEFAULT current_date,
...
other columns
...
);

is there a way to deny any modifications to 'record_creation_date'
without using a view?

Thanks,
Claudio

--
Claudio Succa
PERTEL - Torino - Italy
+39-011-437.4141
http://www.pertel.it
http://www.uniassist.it

In response to

  • Using Views at 2003-11-30 04:01:14 from Christopher Browne

Responses

Browse pgsql-general by date

  From Date Subject
Next Message cadancer 2003-12-12 19:07:46 Perl "with-perl" configuration option
Previous Message Jeff Rogers 2003-12-12 18:58:16 functions returning sets

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-12-12 19:00:09 Resurrecting pg_upgrade
Previous Message David Fetter 2003-12-12 18:57:27 Re: WITH clause