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 ) id 1q0C9u-0003Ge-N2 for pgsql-bugs@arkaria.postgresql.org; Sat, 20 May 2023 02:17:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q0C9t-0002Bi-9c for pgsql-bugs@arkaria.postgresql.org; Sat, 20 May 2023 02:17:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q0C9t-0002BZ-1H for pgsql-bugs@lists.postgresql.org; Sat, 20 May 2023 02:17:25 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q0C9l-000pp9-FG for pgsql-bugs@lists.postgresql.org; Sat, 20 May 2023 02:17:24 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 34K2HEeE639880; Fri, 19 May 2023 22:17:16 -0400 From: Tom Lane To: "=?gb18030?B?Mzk2OTM0NDA2?=" <396934406@qq.com> cc: "=?gb18030?B?cGdzcWwtYnVncw==?=" Subject: Re: ERROR: CREATE DATABASE cannot be executed within a pipeline In-reply-to: References: Comments: In-reply-to "=?gb18030?B?Mzk2OTM0NDA2?=" <396934406@qq.com> message dated "Sat, 20 May 2023 10:06:43 +0800" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <639878.1684549034.1@sss.pgh.pa.us> Date: Fri, 19 May 2023 22:17:14 -0400 Message-ID: <639879.1684549034@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk "=?gb18030?B?Mzk2OTM0NDA2?=" <396934406@qq.com> writes: > When executing DROP DATABASE or CREATE DATABASE statements in JDBC, > other statements cannot be included This restriction is intentional. Previous versions failed to enforce it fully, but you were at serious hazard of problems, up to and including database corruption, if you exploited the missing check. regards, tom lane