PostgreSql : Disallow the update of a column : how? -


Without a trigger, with PostgreSQL, it is possible to not allow updates of a column, just allow insertion is.

Fully untested but Postgres supports SQL column level permissions It seems that it could be

Does this work?

  Select the approval (call1, cola2), INSERT (call1, cola2), UPDATE (col1) mytable on mytable;  

Comments