Bug in CREATE/DROP TABLESPACE command - Mailing list pgsql-general

From William Garrison
Subject Bug in CREATE/DROP TABLESPACE command
Date
Msg-id 45FADD4D.8040004@mobydisk.com
Whole thread Raw
Responses Re: Bug in CREATE/DROP TABLESPACE command  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
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?

pgsql-general by date:

Previous
From: merlyn@stonehenge.com (Randal L. Schwartz)
Date:
Subject: Re: exception handling in plperlu
Next
From: Reece Hart
Date:
Subject: Re: [SQL] PostgreSQL to Oracle