| From: | Matthias Apitz <guru(at)unixarea(dot)de> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | a database can be created but not droped |
| Date: | 2022-08-01 09:22:33 |
| Message-ID: | 20220801092233.GA9@sh4-5.1blu.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
This is with 14.1 on Linux. I have created a new database with
$ createdb -U sisis -T template0 SRP-27097
I can connect to it, created tables and fill them with SQL:
$ psql -Usisis -dSRP-27097
psql (14.1)
Geben Sie »help« für Hilfe ein.
SRP-27097=# select count(*) from sisisinst;
count
-------
2
but I can not drop the database:
$ psql -Usisis -dtestdb
psql (14.1)
Geben Sie »help« für Hilfe ein.
testdb=# DROP DATABASE IF EXISTS SRP-27097 WITH FORCE;
ERROR: syntax error at or near "-"
ZEILE 1: DROP DATABASE IF EXISTS SRP-27097 WITH FORCE;
Why is this?
matthias
--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julien Rouhaud | 2022-08-01 09:27:53 | Re: a database can be created but not droped |
| Previous Message | Rejo Oommen | 2022-08-01 08:12:33 | Is Client connections via ca.crt only possible? |