On Sat, Mar 19, 2005 at 07:03:19PM -0500, Tom Lane wrote: > Possibly, but I'm concerned about locking and deadlock issues. The > reason that this is iffy is you would start the operation with only > an INSERT-grade lock, and then discover that you needed to add a > partition, which is surely something that needs an exclusive-grade > lock (consider two sessions trying to add the same partition at the > same time). So I don't see how to do it without lock upgrading, > and lock upgrading is always a recipe for deadlocks.
What about letting something periodical (say, vacuum) do this? /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster