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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
