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,
pgsql-admin by date
|Next:||From: Alexander Burbello||Date: 2007-01-10 18:03:18|
|Subject: Lob datatype|
|Previous:||From: Sriram Dandapani||Date: 2007-01-10 16:50:38|
|Subject: vacuum very slow|