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?
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? |
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 ? |