Re: Read only column ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Read only column ?
Date: 2010-01-17 01:59:45
Message-ID: 10891.1263693585@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> writes:
> Is there a way to set a column to be read only?

As of 8.4 you could revoke insert/update permissions column-by-column ...

> I have a table with several columns with values that are determined by triggers. I want users to be able to view, but never edit them.

... although, if you have triggers forcibly setting the columns, it
hardly matters what the users try to put into them, no?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2010-01-17 02:09:45 Re: Read only column ?
Previous Message Gauthier, Dave 2010-01-17 01:31:48 Read only column ?