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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-02-22 18:33:02 | Re: Question about "Unrecognized SPI code" ... |
Previous Message | Tom Lane | 2005-02-22 18:05:47 | Re: Get rid of system attributes in pg_attribute? |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-02-22 19:00:56 | Re: [NOVICE] Question on TRUNCATE privleges |
Previous Message | john-paul delaney | 2005-02-22 17:33:44 | Re: recursive processing |