Re: Read only column ? - Mailing list pgsql-general

From Tom Lane
Subject Re: Read only column ?
Date
Msg-id 10891.1263693585@sss.pgh.pa.us
Whole thread Raw
In response to Read only column ?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: Read only column ?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
"Gauthier, Dave" <dave.gauthier@intel.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,
butnever 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

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Read only column ?
Next
From: "Gauthier, Dave"
Date:
Subject: Re: Read only column ?