Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Pg_dump postgreSQL 8.1.3-1 and win2k



I'm trying to dump a schema and I receive this error :
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
pg_dump: *** aborted because of error

The schema was created by a superuser "X", and the dump has been done by another user "Y" which has the privileges : ALL on this table.
grant ALL on table pg_ts_dict to Y;
The owner of pg_ts_dict is "X".
 
Thanks for your answer,
 


Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group