Re: Potential bug in pg_dump ...

Brent Verner <brent(at)rcfile(dot)org> writes:
> [2001-12-17 17:06] Tom Lane said:
> | A possible (partial) solution is for pg_dump to obtain a read-lock on
> | every table in the database as soon as it sees the table mentioned in
> | pg_class, rather than waiting till it's ready to read the contents of
> | the table. However this cure might be worse than the disease,
> | particularly for people running "pg_dump -t table".

> How would this lock-when-seen approach cause problems with '-t'?

Locking the whole DB when you only want to dump one table might be seen
as a denial of service. Also, consider the possibility that you don't
have the right to lock every table in the DB.

If we can arrange to lock only those tables that will end up getting
dumped, then these problems go away. I have not looked to see if that's
a difficult change or not.

regards, tom lane