Re: [GENERAL] Error when trying to drop a tablespace

Tom Lane wrote: Cyril SCETBON [EMAIL PROTECTED] writes: Tom Lane wrote: So which database has OID 100456? select datname from pg_database where oid = 100456; it's not a database oid but a tablespace oid [ squint... ] There shouldn't be any files directly under a

Re: [GENERAL] Error when trying to drop a tablespace

Tom Lane wrote: Cyril SCETBON [EMAIL PROTECTED] writes: Albe Laurenz wrote: is there anything in this directory? find . . ./100456 ./100456/100738 ./100456/102333 ./100456/103442 ./100456/102618 ./100456/104159 ./100456/101234 ./100456/102658 ./100456/104477 So

Re: [GENERAL] Error when trying to drop a tablespace

Albe Laurenz wrote: Cyril SCETBON wrote: 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 : Find out the directory:

Re: [GENERAL] Error when trying to drop a tablespace

Albe Laurenz wrote: Cyril SCETBON wrote: 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 :

Re: [GENERAL] Error when trying to drop a tablespace

Cyril SCETBON wrote: 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 : You can find the dependent objects with: SELECT t.relname AS

Re: [GENERAL] Error when trying to drop a tablespace

Albe Laurenz wrote: Cyril SCETBON wrote: 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 : You can find the dependent

Re: [GENERAL] Error when trying to drop a tablespace

Albe Laurenz wrote: Cyril SCETBON wrote: 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 : postgres=# select * from pg_class where

Re: [GENERAL] Error when trying to drop a tablespace

Cyril SCETBON wrote: 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 : Find out the directory: SELECT oid, spclocation FROM

Re: [GENERAL] Error when trying to drop a tablespace

Cyril SCETBON wrote: 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 : Find out the directory: SELECT oid,

Re: [GENERAL] Error when trying to drop a tablespace

Cyril SCETBON [EMAIL PROTECTED] writes: Albe Laurenz wrote: is there anything in this directory? find . . ./100456 ./100456/100738 ./100456/102333 ./100456/103442 ./100456/102618 ./100456/104159 ./100456/101234 ./100456/102658 ./100456/104477 So which database has OID 100456?

Re: [GENERAL] Error when trying to drop a tablespace

Cyril SCETBON [EMAIL PROTECTED] writes: Tom Lane wrote: So which database has OID 100456? select datname from pg_database where oid = 100456; it's not a database oid but a tablespace oid [ squint... ] There shouldn't be any files directly under a tablespace directory, except possibly a

[GENERAL] Error when trying to drop a tablespace

Hi guys, 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 : postgres=# select * from pg_class where reltablespace=100456; relname |

Re: [GENERAL] Error when trying to drop a tablespace

Cyril SCETBON wrote: 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 : postgres=# select * from pg_class where

Re: [GENERAL] Error when trying to drop a tablespace

Cyril SCETBON [EMAIL PROTECTED] 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

Re: [GENERAL] Error when trying to drop a tablespace

Cyril SCETBON wrote: 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 : postgres=# select * from pg_class where reltablespace=100456;