Re: [GENERAL] error moving table to tablespace - Mailing list pgsql-hackers-win32

From Andreas Pflug
Subject Re: [GENERAL] error moving table to tablespace
Date
Msg-id 411BC79B.7070101@pse-consulting.de
Whole thread Raw
Responses Re: [GENERAL] error moving table to tablespace
List pgsql-hackers-win32
Tom Lane wrote:
> Andreas Pflug <pgadmin@pse-consulting.de> writes:
>
>>I just reproduced this on win32. The file already exists, and is locked.
>
>
> Oh, I'll bet it's the original copy of the table that hasn't been
> removed yet.

You win.

> We may have an issue with SET TABLESPACE failing to close
> the old file, so it can't be deleted yet on Windows ...

Might not be the whole truth, the file *is* deleted when the backend is
shut down. Maybe the OS delays the delete if the file is still open; I'm
not familiar enough with that part of code to verify it.

Regards,
Andreas

pgsql-hackers-win32 by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: [PATCHES] Win32 Event log
Next
From: "Dave Page"
Date:
Subject: Re: [PATCHES] Win32 Event log