Re: Bug in CREATE/DROP TABLESPACE command

What version of PostgreSQL is this? Please provide the SQL commands
that cause this problem, with error output.

---------------------------------------------------------------------------

William Garrison wrote:
> On Windows Server 2003, if you create a tablespace to a location that
> doesn't exist, then try to remove that tablespace, you get an error that
> pg_tblspc/##### does not exist. It appears that postgres created the
> tablespace internally, but not the folder. When you try to drop the
> tablespace, the folder doesn't exist and it reports an error.
>
> This sounds like two interacting bugs:
> 1) The tablespace should not have been created because the symlink could
> not be created.
> 2) It should be possible to remove a tablespace even if the symlink has
> already been deleted manually.
>
> The workaround is to create a pg_tblsc/##### directory then do the drop.
>
> Where do I submit this bug?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +