Re: Read only column ?

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

Ummmm..... Wellll.... I guess you have a point there :-)

Still, it would be nicer for the DB to tell them "DON'T TOUCH THAT" as opposed to a trigger silently overriding whatever they may have thought they changed.

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Saturday, January 16, 2010 9:00 PM
To: Gauthier, Dave
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Read only column ?

"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