Re: [GENERAL] error moving table to tablespace

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-13 10:46:57
Message-ID: 411C9C21.8090707@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers-win32

Tom Lane wrote:
> Andreas Pflug <pgadmin(at)pse-consulting(dot)de> writes:
>
>>Tom Lane wrote:
>>
>>>Oh, I'll bet it's the original copy of the table that hasn't been
>>>removed yet.
>
>
>>You win.
>
>
> I looked at the ALTER TABLE SET TABLESPACE code and saw that it was
> indeed failing to close the original table. I've committed a fix.
> Can someone check that this particular failure mode is gone on Windows
> with CVS tip?

Yes, it's gone. The table file now vanishes immediately from the
previous tablespace dir.

Regards,
Andreas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-08-13 13:47:29 Re: REINDEX problem
Previous Message Richard Huxton 2004-08-13 10:44:00 Re: ODBC Driver Standards

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Joerg Hessdoerfer 2004-08-13 12:57:26 Re: 8.0 Beta 1 // Environment Vars // .pgpass
Previous Message Andreas Pflug 2004-08-13 10:45:12 Re: make fails if path has spaces