Re: [GENERAL] error moving table to tablespace

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема Re: [GENERAL] error moving table to tablespace
Дата
Msg-id 411BC79B.7070101@pse-consulting.de
обсуждение исходный текст
Ответы Re: [GENERAL] error moving table to tablespace
Список 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 по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: [PATCHES] Win32 Event log
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: [PATCHES] Win32 Event log