Re: a database can be created but not droped

2022-08-01 Thread Frank Streitzig
Am Mon, Aug 01, 2022 at 11:22:33AM +0200 schrieb Matthias Apitz: > 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? Please try: DROP DATABASE IF EXISTS "SRP-27097" WITH FORCE;

Re: a database can be created but not droped

2022-08-01 Thread Julien Rouhaud
Hi, On Mon, Aug 01, 2022 at 11:22:33AM +0200, Matthias Apitz wrote: > > 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: > > but I can not drop the database: > > $ psql -Usi

a database can be created but not droped

2022-08-01 Thread Matthias Apitz
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; cou