Skip site navigation (1) Skip section navigation (2)

Question on TRUNCATE privleges

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Question on TRUNCATE privleges
Date: 2005-02-22 18:22:07
Message-ID: 20050222181314.M69552@narrowpathinc.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-novice
Hi All,

I have just discovered that I can speed up one of my functions by a factor of
600 by changing an unqualified DELETE to a TRUNCATE.  Unfortunately, the
function is run by multiple users and I get the error message
   "TESTDB=> TRUNCATE inventory.tbl_item;
   ERROR:  must be owner of relation tbl_item

There is nothing in the documentation
(http://www.postgresql.org/docs/8.0/interactive/sql-truncate.html) about this
restriction ( You see Michael I am still reading the documentation. ;-) )  Do
I get to post my first user comment on the documentation pages?  Do I? Hunh?
Can I? :-)

Is there a way to have multiple owners of a table or otherwise achive this
behavior?

Do I get to post my first user comment on the documentation pages?  Do I?
Hunh? Hunh? Can I? :-)

Kind Regards,
Keith

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2005-02-22 19:00:56
Subject: Re: [NOVICE] Question on TRUNCATE privleges
Previous:From: john-paul delaneyDate: 2005-02-22 17:33:44
Subject: Re: recursive processing

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-02-22 18:33:02
Subject: Re: Question about "Unrecognized SPI code" ...
Previous:From: Tom LaneDate: 2005-02-22 18:05:47
Subject: Re: Get rid of system attributes in pg_attribute?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group