On Fri, 27 Feb 2004, Zeugswetter Andreas SB SD wrote:
>
> > > Ahh. I forgot to detail my ideas on this. It seems to me that we cannot
> > > drop a table space until the directory is empty.
>
> Agreed.
>
> >
> > How would it get to be empty? Are you thinking of some sort of "connect
> > database to tablespace" and "disconnect database from tablespace"
> > commands that would respectively create and delete the per-database
> > subdirectory? That seems moderately reasonable to me. We could then
>
> I would only allow the drop if the directory only contains empty db oid
> directories.
Wouldn't this be better tracked in the dependency tracking that's already
built into postgresql? Checking to see if the directory is empty is open
to race conditions, but locking the dependency tracking while dropping a
tablespace isn't.