Tom Lane wrote: > Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> writes: >> No, it's a backend that's holding the file open, with FILE_SHARE_DELETE. > > If that's the only case we care about covering, then rename might be > enough. I was just wondering what it would take to solve the more > general problem of something holding it open with the wrong flags > at the time we want to get rid of it.
Yes, that's a separate problem, and I think we should address that too. That's what I thought was going on in OP's case at first, the patch I posted in my first reply should address that. I'll try to reproduce that case too, and verify that the patch fixes it. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs