Read-only column - Mailing list pgsql-general

From Claudio Succa
Subject Read-only column
Date
Msg-id 1071255598.1552.35.camel@master.to1.pertel.it
Whole thread Raw
In response to Using Views  (Christopher Browne <cbbrowne@acm.org>)
Responses Re: Read-only column  (Doug McNaught <doug@mcnaught.org>)
List pgsql-general
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



pgsql-general by date:

Previous
From: "Rick Gigger"
Date:
Subject: Re: add column sillyness
Next
From: Doug McNaught
Date:
Subject: Re: Read-only column