Re: pg_dump permissions

On 2005-10-19, Christopher Kings-Lynne  wrote:
> Suppose I have a database with a table in it.  I try to dump that 
> database.  The user I dump as is not the owner of that table nor does it 
> have the SELECT permission on that table.
>
> Why can't I do a schema-only dump of that table?  I find that I need 
> SELECT permission on the table, even though my user can happily query 
> the catalogs.

pg_dump takes an access share lock on everything it touches, to avoid
having the schema change out from under it.

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services