"Thomas F. O'Connell" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
