On 2005-10-19, Christopher Kings-Lynne <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
