From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: Guillaume Lelarge <guillaume@lelarge.info>, Erik Rijkers <er@xs4all.nl>,
        PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17130: Error while executing request
In-reply-to: 
 <CAKFQuwYcuJTHVLsOH+HctbLp2Q03bT=kPGTKs4AxRKEi3C5h2g@mail.gmail.com>
References: <17130-ed04b462a11a08fe@postgresql.org>
 <c846fdc6-0fbf-3944-4f7b-a1ffc15e9045@xs4all.nl>
 <CAECtzeVwbMq2AFXN71wq7GT5PK_m3d5pt+pUC=BPKFo3or2aGw@mail.gmail.com>
 <CAKFQuwYcuJTHVLsOH+HctbLp2Q03bT=kPGTKs4AxRKEi3C5h2g@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Tue, 03 Aug 2021 06:18:23 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1703316.1627998725.1@sss.pgh.pa.us>
Date: Tue, 03 Aug 2021 09:52:05 -0400
Message-ID: <1703317.1627998725@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1703317.1627998725%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tue, Aug 3, 2021 at 6:13 AM Guillaume Lelarge <guillaume@lelarge.info>
> wrote:
>> Actually, the syntax should be valid. You can add a DDL right after CREATE
>> SCHEMA without a semicolon in between (see the examples on
>> https://www.postgresql.org/docs/13/sql-createschema.html). But I fail to
>> explain why it doesn't work here. A workaround would be to add the
>> semicolon as you said, but it should work without.

> CREATE TABLE and CREATE TABLE AS are two very different commands and only
> the former is documented to work.

Right.  CREATE SCHEMA allows additional DDL to create objects within
the schema right away, but it only does DDL not DML, so you can't
additionally populate the table as part of the command.

			regards, tom lane