2011/2/8, Mike Christensen <mike(at)kitchenpc(dot)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