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

2008-06-19 Thread Cyril SCETBON
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 : Fi

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

2008-06-19 Thread Cyril SCETBON
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

2008-06-19 Thread Cyril SCETBON
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 w

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

2008-06-19 Thread Cyril SCETBON
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 tab

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

2008-06-18 Thread Tom Lane
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 possi

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

2008-06-18 Thread Tom Lane
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

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

2008-06-18 Thread Albe Laurenz
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

2008-06-18 Thread Albe Laurenz
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

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

2008-06-18 Thread Cyril SCETBON
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

2008-06-18 Thread Cyril SCETBON
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

2008-06-18 Thread Albe Laurenz
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 de

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

2008-06-17 Thread Albe Laurenz
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 w

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

2008-06-17 Thread Tom Lane
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 differen

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

2008-06-17 Thread Albe Laurenz
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 reltablesp

[GENERAL] Error when trying to drop a tablespace

2008-06-17 Thread Cyril SCETBON
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 | relna