Re: [GENERAL] error moving table to tablespace
Andreas Pflug <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32 |
|---|---|
| Message-ID | <[email protected]> |
Tom Lane wrote: > Andreas Pflug <[email protected]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster