| 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
| 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 |
| 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 |