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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1236: still in use tablespaces can be removed
Date: 2004-10-07 18:33:48
Message-ID: 200410071833.i97IXmY26033@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomasz Kuźniar 2004-10-07 19:25:24 postgres 8.0.0beta3 problem
Previous Message Bruce Momjian 2004-10-07 17:29:11 Re: pgsql 8.0 beta1 patch for token and timezone