pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Kenneth Gonsalves <lawgon@thenilgiris.com>
To: PostgreSQL SQL <pgsql-sql@postgresql.org>
Subject: preventing deletion of a row
Date: Tue, 7 Jun 2005 10:59:17 +0530
Message-ID: <200506071059.17689.lawgon@thenilgiris.com> (raw)

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
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!


view thread (3+ messages)  latest in thread

Message-ID: <200506071059.17689.lawgon@thenilgiris.com>
Permalink:  ../200506071059.17689.lawgon@thenilgiris.com/
Also on:    postgresql.org/message-id/200506071059.17689.lawgon@thenilgiris.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: lawgon@thenilgiris.com
  Subject: Re: preventing deletion of a row
  In-Reply-To: <200506071059.17689.lawgon@thenilgiris.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox