preventing deletion of a row

From: Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com>
To: PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org>
Subject: preventing deletion of a row
Date: 2005-06-07 05:29:17
Message-ID: 200506071059.17689.lawgon@thenilgiris.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hi
i have a table of the type:

id serial unique,
name varchar(50),
fixed boolean default FALSE

if the value of 'fixed' is TRUE, then this row cannot be deleted. How
do i enforce this condition?
--
regards
kg

http://www.livejournal.com/users/lawgon
tally ho! http://avsap.sourceforge.net
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Kenneth Gonsalves 2005-06-07 05:31:49 datestyle syntax
Previous Message Joe Conway 2005-06-07 01:24:52 Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp.