Re: Query - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Query
Date
Msg-id 20080624125508.GI15187@a-kretschmer.de
Whole thread Raw
In response to Query  ("kartik" <kartik@v2technocrats.com>)
List 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

pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: Query
Next
From: Ludwig Kniprath
Date:
Subject: Re: Query