Re: [HACKERS] [PATCHES] TRUNCATE, VACUUM, ANALYZE privileges

2006-01-05 Thread Rod Taylor
On Thu, 2006-01-05 at 09:41 -0500, Stephen Frost wrote: > * Michael Paesold ([EMAIL PROTECTED]) wrote: > > Stephen Frost wrote: > > >I'm not a particularly big fan of this though because, while I'd > > >like to be able to give TRUNCATE permissions I'm not a big fan of SET > > >RELIABILITY because i

Re: [HACKERS] [PATCHES] TRUNCATE, VACUUM, ANALYZE privileges

2006-01-05 Thread Stephen Frost
* Michael Paesold ([EMAIL PROTECTED]) wrote: > Stephen Frost wrote: > >I'm not a particularly big fan of this though because, while I'd > >like to be able to give TRUNCATE permissions I'm not a big fan of SET > >RELIABILITY because it would affect PITR backups. > > As far as I have understood the

Re: [HACKERS] [PATCHES] TRUNCATE, VACUUM, ANALYZE privileges

2006-01-05 Thread Michael Paesold
Stephen Frost wrote: I'm not a particularly big fan of this though because, while I'd like to be able to give TRUNCATE permissions I'm not a big fan of SET RELIABILITY because it would affect PITR backups. As far as I have understood the discussion... with WAL archiving turned on, the whole RE

Re: [HACKERS] [PATCHES] TRUNCATE, VACUUM, ANALYZE privileges

2006-01-05 Thread Stephen Frost
Tom, et al, Sorry for the longish email; if you're most interested in a change to the ACL system to allow more privileges then skip to the bottom where I worked up a change to give us more options without much of a performance impact (I don't think anyway). Personally, I'd prefer that to overload