Ver Mensaje Individual
  #4 (permalink)  
Antiguo 08/10/2011, 05:26
Anarko
 
Fecha de Ingreso: febrero-2004
Mensajes: 1.987
Antigüedad: 20 años, 2 meses
Puntos: 22
Respuesta: cuando corro el comando DROP DATABASE tal, no sucede NADA

Intento mostrar lo + explicito posible, puede verse que me conecto con postgres:
Código:
Using username "root".
root@MYSERVER's password:
Last login: Sat Oct  8 06:04:54 2011 from MYIP
root@GV [~]# su postgres
bash-3.2$ psql
could not change directory to "/root"
Password:
psql (8.4.4)
Type "help" for help.

postgres=# \l
                                     List of databases
       Name       |  Owner   | Encoding |  Collation  |    Ctype    |   Access privileges
------------------+----------+----------+-------------+-------------+-----------------------
 user5_test      | user5   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user5
                                                                    : user5=CTc/user5
 user7_Prueba       | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_SSHR         | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_abril2011    | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_qqq          | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_qwqw         | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_ret          | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_rr           | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_sa           | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_t            | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_tres         | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_wqwq         | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_wwwsaq       | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 postgres         | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0        | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
postgres=#
postgres=# postgres=#DROP DATABASE user7_wwwsaq
postgres-# postgres=#DROP DATABASE user7_tres
postgres-# postgres=#DROP DATABASE user7_sa
postgres-#
postgres=# \l
                                     List of databases
       Name       |  Owner   | Encoding |  Collation  |    Ctype    |   Access privileges
------------------+----------+----------+-------------+-------------+-----------------------
 user5_test      | user5   | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user5
                                                                    : user5=CTc/user5
 user7_Prueba       | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_SSHR         | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_abril2011    | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_qqq          | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_qwqw         | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_ret          | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_rr           | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_sa           | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_t            | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_tres         | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_wqwq         | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 user7_wwwsaq       | user7      | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/user7
                                                                    : user7=CTc/user7
 postgres         | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0        | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
postgres=#
No devuelve ni error ni trunfo...
se queda mudo y al repetir \l continua listandolas BD