Re: Postgresql13_beta1 (could not rename temporary statistics file)Windows 64bits - Mailing list pgsql-hackers

From Ranier Vilela
Subject Re: Postgresql13_beta1 (could not rename temporary statistics file)Windows 64bits
Date
Msg-id CAEudQAqVDaYzbGK=DxO5MDbga9GNAE_sxeSh_JtNZNAS-S1W0A@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql13_beta1 (could not rename temporary statistics file)Windows 64bits  (Ranier Vilela <ranier.vf@gmail.com>)
List 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

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: problem with RETURNING and update row movement
Next
From: Andres Freund
Date:
Subject: Re: hashagg slowdown due to spill changes