Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 011C1476E0C
	for <pgsql-sql@postgresql.org>; Thu, 26 Sep 2002 14:56:39 -0400 (EDT)
Received: from mail-relay.trade-india.com (mail-relay.trade-india.com
	[203.196.129.235])
	by postgresql.org (Postfix) with SMTP id A0AFF476DBB
	for <pgsql-sql@postgresql.org>; Thu, 26 Sep 2002 14:56:35 -0400 (EDT)
Received: (qmail 23011 invoked from network); 26 Sep 2002 18:47:06 -0000
Received: from system67.trade-india-local.com (192.168.0.67)
	by infocom-236-129-del.trade-india.com with SMTP;
	26 Sep 2002 18:47:06 -0000
Content-Type: text/plain;
  charset="us-ascii"
From: "Rajesh Kumar Mallah." <mallah@trade-india.com>
Organization: Infocom Network Limited.
To: pgsql-sql@postgresql.org
Subject: Preventing DELETEs
Date: Fri, 27 Sep 2002 00:30:16 +0530
User-Agent: KMail/1.4.1
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200209270030.16040.mallah@trade-india.com>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/332
X-Sequence-Number: 9609

Hi ,

I have a created a database and a table in it,

I want to prevent "DELETES" on the table in this
database by everyone except superuser postgres.
even by me (the creator of this database and table)


I have tried in many ways (ALTER TABLE REVOKE DELETE .. etc etc)

but i  always end up with having the permission


can any one tell me how the prevention can be accomplished?

thanks in advance.

regds
mallah.



--=20
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.