| 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: | Whole Thread | Raw Message | 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 |