On 2005-10-19, Christopher Kings-Lynne <chriskl@familyhealth.com.au> 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
