| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Immutable attributes? |
| Date: | 2005-04-24 21:53:51 |
| Message-ID: | 20050424215351.GA31885@fetter.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Apr 24, 2005 at 09:26:49PM +0200, Stephane Bortzmeyer wrote:
> To protect the database from programming errors (there is a team
> working on the project and some beginners may produce bugs), I would
> like to flag some attributes as immutable, meaning non modifiable in
> an UPDATE. (Typical examples are ID or creation time.)
>
> Currently, I use triggers:
You could use RULEs instead, but the effect would be similar.
> PostgreSQL 7.4, switching to 8.0 would be difficult.
Now is easier than later.
Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajiv Verma | 2005-04-24 22:08:13 | SQLException "Connection is closed. Operation is not permitted" |
| Previous Message | Zlatko Matic | 2005-04-24 20:28:28 | Re: psqlodbc MSAccess and Postgresql |