Just installed PostgreSQL 8.3.0 for the first time and trying to
install the paglia DB.
Unfortunately when I used
CREATE TABLESPACE pagila_system
OWNER pagila
I set the LOCATION as wrong and know want to drop the tablespace.
Got as far as
DROP TABLESPACE pagila_system;
then received:
ERROR: tablespace "pagila_system" is not empty
Got this:-
\db+ pagila_system
List of tablespaces
Name | Owner |
Location |
Access privileges | Description
---------------+--------
+------------------------------------------------------+
-------------------+-------------
pagila_system | pagila | C:/Documents and Settings/All Users/
Documents/pgdata |
|
(1 row)
How can I get rid of TABLESPACE pagila_system ?
