Tom Lane wrote: > > Hiroshi Inoue <[EMAIL PROTECTED]> writes: > > One backend would be blocked by another one because reindex_relation > > calls reindex_index and reindex_index grabs an ExclusiveLock on the > > relation. > > Am I missing anything ? > > It'd be okay if you *held* the lock throughout. Grabbing and releasing > it isn't safe IMHO.
Maybe I'm slow on the uptake because I've just finished a short vacation. Where do I release the lock ? regards, Hiroshi Inoue ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
