Don't change thread subjects, it confuses people. Start a new thread if you have a new topic.
In response to Peter Billen <[EMAIL PROTECTED]>: > > What is the best way to disallow updates on a column of a table, or even > on a whole table itself? > > I can write a BEFORE UPDATE trigger which compares old.column_name(s) to > new.column_name(s) and raise an exception if these values are different. > > Are there better ways? You can use the GRANT system to enforce table-wide restrictions. See the docs on GRANT and REVOKE and associated doc sections. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
