Tom Lane wrote:
>
> Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> 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