| From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers-win32(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] error moving table to tablespace |
| Date: | 2004-08-12 19:40:11 |
| Message-ID: | 411BC79B.7070101@pse-consulting.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers-win32 |
Tom Lane wrote:
> Andreas Pflug <pgadmin(at)pse-consulting(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arthur van Dorp | 2004-08-12 20:31:47 | Re: Strange pg_hba.conf error (repost) |
| Previous Message | Marc G. Fournier | 2004-08-12 19:35:14 | Re: PostgreSQL 8.0 Feature List? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2004-08-12 20:04:23 | Re: [PATCHES] Win32 Event log |
| Previous Message | Andreas Pflug | 2004-08-12 19:32:22 | Re: Win32 Event log |