Re: BUG #1236: still in use tablespaces can be removed

Added to open items list:

* Fix error message when creating objects in schema that has a
dropped tablespace as its default

I can confirm the bug still exists in CVS.

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

Fabien COELHO wrote:
>
> Dear Tom,
>
> > > Suggested fix: create some empty file in the directory
> > > if it is used by a namespace.
> >
> > This was discussed and rejected before --- the problem is not worth the
> > amount of mechanism that would have to be added to fix it this way.
> > See the pghackers archives, but I believe the main problem is that a
> > namespace is not a table and so none of the mechanisms that support file
> > creation/deletion will work with it.
>
> I just made a small suggestion on how to fix it, and I agree that it
> may not be appropriate. I just seemed a simple solution wrt to how
> pg decides how the tablespace may be removed.
>
> As for reading the pghackers history on tablespace, I guess that beta is
> for testing the software and reporting issues. So I spend some time
> testing new features, and if there is a problem I report it. If you thing
> the problem is not worth solving, well, I've made my part by testing and
> reporting it!
>
> >From what I've seen aboutt tablespaces, it seems to me that the
> implementation is just NOT finished, whether beta freeze or not. This
> means that anyone that who will use this feature in 8.0 will run into
> these issues.
>
> Have a nice day,
>
> --
> Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073