On Sat, 2011-01-01 at 11:06 -0500, Robert Haas wrote:
> While reviewing the SQL/MED patch, I happened to notice that
> ExecAlterObjectSchemaStmt calls AlterTableNamespace with a lock mode
> argument of AccessExclusiveLock. Does anyone see a reason why
> ShareUpdateExclusiveLock would be insufficient?
It seemed unsafe to me to do that while an object was being accessed,
since it effectively changes the search_path, which is dangerous.
Seems like a good change, if it really is viable.
-- Simon Riggs http://www.2ndQuadrant.com/books/PostgreSQL Development, 24x7 Support, Training and Services