2011/2/8, Mike Christensen <m...@kitchenpc.com>: > Here's the error: > > pg_dump: SQL command failed > pg_dump: Error message from server: ERROR: permission denied for > relation pantryitems > pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE MODE > > Does the user need to be a superuser, or is there some way to GRANT > this permission (if possible, I don't want this user to be able to > modify the schema).. >
this lock need only SELECT privilege. ------------ pasman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
