Обсуждение: 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?