On Mon, 26 Mar 2007, Tom Lane wrote:
"Robert James" <srobertjames@xxxxxxxxx> 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@xxxxxxxxxx, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
