Re: pg_dump without psql rights

On Mon, 26 Mar 2007, Tom Lane wrote:

> "Robert James" <srobertjames@gmail.com> writes:
>> I'm getting this error:
>> pg_dump: SQL command failed
>> pg_dump: Error message from server: ERROR: permission denied for relation
>> pg_ts_dict
>> pg_dump: The command was: LOCK TABLE public.pg_ts_dict IN ACCESS SHARE MODE
>
>> Is there anyway I can do a pg_dump as non psql?  Perhaps without locks?
>
> No.  However, I am wondering why it is that tsearch2 doesn't make its
> config tables publicly readable ...

config tables are like other user created tables, the same access policy.
It's up to user grant access to them.


     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83