Re: BUG #17806: PostgreSQL 13.10 returns "CREATE DATABASE cannot be executed within a pipeline"

From: Wesley Smith <wesley(dot)smith(at)exterro(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: wesley(dot)smith(at)zapproved(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17806: PostgreSQL 13.10 returns "CREATE DATABASE cannot be executed within a pipeline"
Date: 2023-02-24 19:36:28
Message-ID: CADr-msaYG=wdJSvvTzEe5V=zw=vwGRWXGMyAP-NaeOOc31d+qw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Feb 24, 2023 at 7:56 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Munro 2023-02-24 19:56:18 Re: BUG #17744: Fail Assert while recoverying from pg_basebackup
Previous Message Tom Lane 2023-02-24 17:48:38 Re: BUG #17800: ON CONFLICT DO UPDATE fails to detect incompatible fields that leads to a server crash