Re: Error when trying to drop a tablespace

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Cyril SCETBON <scetbon(at)echo(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error when trying to drop a tablespace
Date: 2008-06-17 12:39:35
Message-ID: 18959.1213706375@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Cyril SCETBON <scetbon(at)echo(dot)fr> writes:
> I get the following error :

> postgres=# DROP TABLESPACE IF EXISTS my_tbs;
> ERROR: tablespace "my_tbs" is not empty

> I've searched in pg_class and I'm not able to find a relation which
> refers to my_tbs with :

Maybe there's something in a different database?

I'd just look into the filesystem and see what's underneath the
tablespace directory ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Philippe Grégoire 2008-06-17 12:56:55 Re: inserting to a multi-table view
Previous Message Markus Wollny 2008-06-17 12:35:32 Re: Slony-I configuration problem, probably due to custom casts in 8.3