Re: Dont allow updation for few columns in a record. - Mailing list pgsql-novice

On Wed, Jul 09, 2003 at 11:40:24 +0530,
  HK <harikrishnan@midascomm.com> wrote:
> Hi all,
>     Is it possible to say that once a record is inserted into the
> table, nobody can update some particular columns in that record.
>
> (eg)
> table
> ------
> prod_id prod_name prod_desc
>   1      name1      desc1
>   2      name2      desc2
>
> In this table i dont want to allow updation of the prod_name column.
>
> I can write a trigger to do this job, but is there any way to specify
> during the table creation time itself that these columns cannot be
> altered.

One option would be not to grant UPDATE access to the table.