Re: [HACKERS] permission inconsistency with functions

2010-07-23 Thread Joshua D. Drake
On Fri, 2010-07-23 at 21:55 +0300, Peter Eisentraut wrote: > On fre, 2010-07-23 at 11:48 -0700, Joshua D. Drake wrote: > > "In particular, it must have read access to all tables that you want > > to > > back up, so in practice you almost always have to run it as a database > > superuser." > > > >

Re: [HACKERS] permission inconsistency with functions

2010-07-23 Thread Peter Eisentraut
On fre, 2010-07-23 at 11:48 -0700, Joshua D. Drake wrote: > "In particular, it must have read access to all tables that you want > to > back up, so in practice you almost always have to run it as a database > superuser." > > Ignoring the fact that databases have a lot more objects than tables, > t

[HACKERS] permission inconsistency with functions

2010-07-23 Thread Joshua D. Drake
Hello, I am writing a blog on backups with postgresql, which I plan at some point (if someone doesn't beat me to it) on turning into a patch for the docs but I found this inconsistency: The docs state that: "In particular, it must have read access to all tables that you want to back up, so in pr