Re: [GENERAL] error moving table to tablespace
Andreas Pflug <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32,gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <[email protected]> |
Tom Lane wrote: > Christian Traber <[email protected]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match