| From: | Andrew - Supernews <andrew+nonews(at)supernews(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: pg_dump permissions |
| Date: | 2005-10-19 12:31:46 |
| Message-ID: | slrndlcf5i.2db7.andrew+nonews@trinity.supernews.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2005-10-19, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew - Supernews | 2005-10-19 12:40:40 | Re: Question about Ctrl-C and less |
| Previous Message | Kevin Brown | 2005-10-19 11:24:21 | Re: Question about Ctrl-C and less |