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

From Andreas Pflug
Subject Re: [pgsql-hackers-win32] error moving table to tablespace
Date
Msg-id 411B38C4.2010908@pse-consulting.de
Whole thread Raw
In response to Re: error moving table to tablespace (8.0 beta win32 )  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [pgsql-hackers-win32] error moving table to tablespace (8.0 beta win32 )  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Christian Traber <christian@traber-net.de> writes:
>
>>Maybe its only win32 version?
>
>
> Well, I can't reproduce it on Unix.  It seems awfully odd though that
> you can create tables in that tablespace to begin with but can't move
> them there.  I'm cc'ing this to the pgsql-hackers-win32 to see if anyone
> there has a clue ...

I just reproduced this on win32. The file already exists, and is locked.
  Apparently, in this case it's the very same backend that's locking the
file; closing the connection that was used to move the table into the
other tablespace will remove the file immediately.

Regards,
Andreas

pgsql-general by date:

Previous
From: "Michael Kleiser"
Date:
Subject: Re: disabling autocommit
Next
From: Richard Huxton
Date:
Subject: Re: How to identify which query is running - reg.