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 |