Re: Postgresql13_beta1 (could not rename temporary statistics file) Windows 64bits

From: Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgresql13_beta1 (could not rename temporary statistics file) Windows 64bits
Date: 2020-06-14 16:41:50
Message-ID: CAEudQAqVDaYzbGK=DxO5MDbga9GNAE_sxeSh_JtNZNAS-S1W0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

posix rename, "renames a file, moving it between directories if required".

pgrename, win32 port uses MoveFileEx, to support rename files at Windows
side,
but, actually don't allow "renames a file, moving it between directories if
required".

To match the same characteristics as posix rename, we need to add a flag to
MoveFileEx (MOVEFILE_COPY_ALLOWED)
Which allows, if necessary, to move between volumes, drives and directories.

Such a resource seems to decrease the chances of occurring, permission
denied, when renaming the temporary statistics file.

Attachment Content-Type Size
allow_win32_rename_across_volumes.patch application/octet-stream 467 bytes

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2020-06-14 18:14:18 Re: hashagg slowdown due to spill changes
Previous Message Amit Langote 2020-06-14 13:48:12 Re: problem with RETURNING and update row movement