|
From: mei le <lem...@ya...> - 2010-11-08 10:13:12
|
Dears,
the steps as follows:
postgres=# create database dbt1;
CREATE DATABASE
postgres=# \c dbt1
psql (8.4.3)
You are now connected to database "dbt1".
dbt1=# create table t(a int);
CREATE TABLE
dbt1=# \c postgres
psql (8.4.3)
You are now connected to database "postgres".
postgres=# drop database dbt1;
ERROR: database "dbt1" is being accessed by other users
DETAIL: There are 1 other session(s) using the database.
In addition,it's ok to drop databse if I didn't create any object in database dbt1.
regards,
Benny
|