cuando corro el comando DROP DATABASE tal, no sucede NADA

Anarko · #1 (**permalink**) 01/10/2011, 14:11

Hola.

Entro como user postgres.

cuando corro el comando DROP DATABASE tal, no sucede NADA

El OWNER tiene que ser postgres ?

huesos52 · #2 (**permalink**) 03/10/2011, 06:00

Como sabes que no hace nada? se queda pensando? o dice que la borra pero sigue existiendo?

saludos

cacr · #3 (**permalink**) 07/10/2011, 13:36

Cuál es exactamente el comando que ejecutas? con cuál cliente?

Anarko · #4 (**permalink**) 08/10/2011, 05:26

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

huesos52 · #5 (**permalink**) 08/10/2011, 18:42

debes poner ; al final de la sentencias DROP DATABASE.

Anarko · #6 (**permalink**) 09/10/2011, 11:36

:|

con un ; funciono perfecto !!!

Joder tios !

Huesos:

Alguna idea de un QUERY para ver ULTIMO ACCESO a una BD ?

Gracias !