hello
2008/6/24 kartik <[EMAIL PROTECTED]>:
> Hello there
>
> Can anyone please tell me how to make a column uneditable….
>
> Plz give me some output
>
> thans
try trigger
create table foo(
a varchar
);
create function a_update_trg()
returns trigger as $$
begin
if new.a is distinct from old.a then
raise exception 'cannot change column a';
end;
return new;
end;
$$ language plpgsql;
create trigger foo_trg_update after update on foo for each row execute
procedure a_update_trg();
regards
Pavel Stehule
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
