Bug in CREATE/DROP TABLESPACE command

From: William Garrison <postgres(at)mobydisk(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Bug in CREATE/DROP TABLESPACE command
Date: 2007-03-16 18:09:17
Message-ID: 45FADD4D.8040004@mobydisk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonah H. Harris 2007-03-16 18:20:35 Re: [SQL] PostgreSQL to Oracle
Previous Message Stefan Berglund 2007-03-16 17:57:48 Re: Is This A Set Based Solution?

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2007-03-16 18:14:22 Re: Bug in UTF8-Validation Code?
Previous Message Gregory Stark 2007-03-16 18:05:03 Re: Question: pg_class attributes and race conditions ?