Re: Query

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Query
Date: 2008-06-24 12:55:09
Message-ID: 20080624125508.GI15187@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

am Tue, dem 24.06.2008, um 15:19:46 +0530 mailte kartik folgendes:
> Hello there
>
> Can anyone please tell me how to make a column uneditable?.

You can write a TRIGGER to avoid changes on the column. Within the
TRIGGER you can compare OLD.column with NEW.column and there you can
raise an error if there are differences.

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

In response to

  • Query at 2008-06-24 09:49:46 from kartik

Browse pgsql-general by date

  From Date Subject
Next Message Ludwig Kniprath 2008-06-24 13:46:55 Re: Query
Previous Message Pavel Stehule 2008-06-24 12:47:53 Re: Query