Re: ERROR: tablespace "archive2" is not empty

On Mon, Oct 19, 2015 at 07:38:32AM -0700, Adrian Klaver wrote:
> What happens if you do?:
>
> select oid, * from pg_tablespace ;

mydb=> select oid, * from pg_tablespace where spcname = 'archive2';
   oid   | spcname  | spcowner |     spclocation      | spcacl | spcoptions
---------+----------+----------+----------------------+--------+------------
 7849107 | archive2 |       10 | /media/archive2/psql |        |
(1 row)

> select * from pg_class where reltablespace = <archive2 oid>;

mydb=> select * from pg_class where reltablespace = 7849107;
 relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples |
reltoastrelid| reltoastidxid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids
|relhaspkey | relhasrules | relhastriggers | relhassubclass | relfrozenxid | relacl | reloptions 

---------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------+------------+-------------+----------------+----------------+--------------+--------+------------
(0 rows)

It's there, but it's not there-there :)

--
     2. That which causes joy or happiness.