> If we don't lock it then we will have a inconsistent dump that will fail > later, if dumped while an object is being dropped. > Do we want an inconsistent dump?
The dump won't be inconsistent, as Tom pointed out. The catalog tables are read using a repeatable read transaction, which will be consistent.
The scan is consistent, yes, but the results would not be.
--
Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services