Question on TRUNCATE privleges
| От | Keith Worthington |
|---|---|
| Тема | Question on TRUNCATE privleges |
| Дата | |
| Msg-id | 20050222181314.M69552@narrowpathinc.com обсуждение исходный текст |
| Ответы |
Re: Question on TRUNCATE privleges
|
| Список | 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
В списке pgsql-novice по дате отправления: