Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1m4Ieu-0007qa-DQ
	for pgsql-bugs@arkaria.postgresql.org; Fri, 16 Jul 2021 07:53:20 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1m4Iet-0008EN-9R
	for pgsql-bugs@arkaria.postgresql.org; Fri, 16 Jul 2021 07:53:19 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <sk@zsrv.org>)
	id 1m4Iet-0008ED-2T
	for pgsql-bugs@lists.postgresql.org; Fri, 16 Jul 2021 07:53:19 +0000
Received: from forward103j.mail.yandex.net ([5.45.198.246])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <sk@zsrv.org>)
	id 1m4Iej-0001At-Rq
	for pgsql-bugs@lists.postgresql.org; Fri, 16 Jul 2021 07:53:17 +0000
Received: from myt6-10de976bd0de.qloud-c.yandex.net
 (myt6-10de976bd0de.qloud-c.yandex.net
 [IPv6:2a02:6b8:c12:2493:0:640:10de:976b])
	by forward103j.mail.yandex.net (Yandex) with ESMTP id CC2B667423B7;
	Fri, 16 Jul 2021 10:53:04 +0300 (MSK)
Received: from mail.yandex.ru (mail.yandex.ru [217.66.154.177])
	by myt6-10de976bd0de.qloud-c.yandex.net (mxback/Yandex) with HTTP id
 3rOuAk0HASw1-r4HS8Tfp;
	Fri, 16 Jul 2021 10:53:04 +0300
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zsrv.org; s=mail;
 t=1626421984;
	bh=VCmuA5nm+7+df7hm8uWiQ7qej01quftsa0k3R9tYp0M=;
	h=References:Date:Message-Id:Subject:In-Reply-To:To:From;
	b=WdBRF1qk42GADTIerg1okr3CWsQSBLQzTnZdpc6glSPoIhp5NKJi966mg9x7V9AlO
	 TAN9YsJAKG5hUzBgFUDqAsXyQVS1Xc0sPOJxHU+Gzm3gxt55HWxwlXLykG44JOnRdn
	 WUSBQU3vQKYq46uLxRN0QvaJzzrvwDGg+lt5DYRA=
Authentication-Results: myt6-10de976bd0de.qloud-c.yandex.net;
 dkim=pass header.i=@zsrv.org
Received: by myt5-7210d748eb79.qloud-c.yandex.net with HTTP;
	Fri, 16 Jul 2021 10:53:03 +0300
From: Sergei Kornilov <sk@zsrv.org>
To: "bernaridho@outlook.co.id" <bernaridho@outlook.co.id>,
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
In-Reply-To: <17111-c66d4212978a0260@postgresql.org>
References: <17111-c66d4212978a0260@postgresql.org>
Subject: Re: BUG #17111: Database created, cannot be created,
 but reported as inexist
MIME-Version: 1.0
X-Mailer: Yamail [ http://yandex.ru ] 5.0
Date: Fri, 16 Jul 2021 10:53:03 +0300
Message-Id: <1243431626421694@mail.yandex.ru>
Content-Transfer-Encoding: 7bit
Content-Type: text/plain
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/1243431626421694%40mail.yandex.ru>
Precedence: bulk

Hello

Please take a look at the register of names.

> FATAL: database "Database" does not exist
> ERROR: database "database" already exists

According SQL syntax https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS "DROP DATABASE Database;" means "DROP DATABASE database;"

regards, Sergei