"Thomas F. O'Connell" <tfo@xxxxxxxxxxxx> writes: > I'm dealing with an application that can potentially do ad hoc DDL. > It uses a PG/pgSQL function, and the only DDL statements in the > function are CREATE TABLE and CREATE INDEX statements. But I'm > noticing that during the backup process (with pg_dump or pg_dumpall), > the function is acquiring ACCESS EXCLUSIVE locks and bringing the > application to its knees. Please provide a test case. AFAIR neither of those should take any AccessExclusive locks --- except on the new table, which shouldn't matter because pg_dump won't see it. regards, tom lane
