Re: BUG #17806: PostgreSQL 13.10 returns "CREATE DATABASE cannot be executed within a pipeline" - Mailing list pgsql-bugs

From Wesley Smith
Subject Re: BUG #17806: PostgreSQL 13.10 returns "CREATE DATABASE cannot be executed within a pipeline"
Date
Msg-id CADr-msaYG=wdJSvvTzEe5V=zw=vwGRWXGMyAP-NaeOOc31d+qw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17806: PostgreSQL 13.10 returns "CREATE DATABASE cannot be executed within a pipeline"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Fri, Feb 24, 2023 at 7:56 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> It is intended that we disallow CREATE DATABASE within a pipeline,
> and has been since 13.8 et al; but we fixed some bugs in that
> prohibition in 13.10.  Looking at the release-note entry about it,
> that only mentions ANALYZE, which is probably my own oversight.
>

Tom,

Thanks for the clarification that this is expected behavior.  I'll
update my code to put the "CREATE DATABASE" line in a separate call.

-- Wesley Smith



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #17800: ON CONFLICT DO UPDATE fails to detect incompatible fields that leads to a server crash
Next
From: Thomas Munro
Date:
Subject: Re: BUG #17744: Fail Assert while recoverying from pg_basebackup