Обсуждение: quit milis
I want quit milis postgresql. thank you. Mulai chatting dengan teman di Yahoo! Pingbox baru sekarang!! Membuat tempat chat pribadi di blog Anda sekarang sangatlahmudah. http://id.messenger.yahoo.com/pingbox/
Tonny Sapri wrote: > I want quit milis postgresql. There is a form you can fill in here: http://www.postgresql.org/community/lists/ -- Richard Huxton Archonet Ltd
Hi all, 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? Certain properties cannot be changed once inserted. I would like to enforce that in my database schema. Thanks in advance. Kind regards, Peter
Don't change thread subjects, it confuses people. Start a new thread if you have a new topic. In response to Peter Billen <peter@clueless.be>: > > 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/ wmoran@collaborativefusion.com Phone: 412-422-3463x4023
Tonny Sapri, 10.12.2008 09:12: > I want quit milis postgresql. What are quit milis?