>
> config tables are like other user created tables, the same access policy.
> It's up to user grant access to them.
True, but the tables should be created with the same owner as the
database. I'm finding that they're created with owner "postgres" even
though the database they're created in has a
On Mon, 26 Mar 2007, Tom Lane wrote:
"Robert James" <[EMAIL PROTECTED]> 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
"Robert James" <[EMAIL PROTECTED]> 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_
I'd like to run pg_dump on a database that I have full
read/write/create/drop access to, but am not running as psql.
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
