X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 9F1EA52A77
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat,  5 Mar 2005 05:02:34 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 21945-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat,  5 Mar 2005 05:02:25 +0000 (GMT)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 4FB8F52A62
	for <pgsql-sql@postgresql.org>; Sat,  5 Mar 2005 05:02:23 +0000 (GMT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j2552JGa014191;
	Sat, 5 Mar 2005 00:02:19 -0500 (EST)
To: "Lynwood Stewart" <lynwood@nwlink.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: truncating table permissions 
In-reply-to: <112ctegjgsa7a5f@corp.supernews.com> 
References: <112ctegjgsa7a5f@corp.supernews.com>
Comments: In-reply-to "Lynwood Stewart" <lynwood@nwlink.com>
	message dated "Wed, 02 Mar 2005 18:30:11 -0800"
Date: Sat, 05 Mar 2005 00:02:19 -0500
Message-ID: <14190.1109998939@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200503/76
X-Sequence-Number: 20555

"Lynwood Stewart" <lynwood@nwlink.com> writes:
> I was expecting "truncate table <tablename>" to truncate a table if I had 
> delete permissions.  This does not appear to be the case.

No, TRUNCATE is restricted to the table's owner, regardless of any
grantable permissions.

This was (ahem) inadequately documented until very recently.

			regards, tom lane