Re: [PATCH] Add --syntax to postgres for SQL syntax checking

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>

To: Robert Haas <robertmhaas@gmail.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Josef Šimánek <josef.simanek@gmail.com>, Tomas Vondra <tomas.vondra@enterprisedb.com>, Laurenz Albe <laurenz.albe@cybertec.at>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2024-05-16T01:39:14Z

Lists: pgsql-hackers

On Wed, May 15, 2024 at 6:35 PM David G. Johnston <
david.g.johnston@gmail.com> wrote:

>
> If in core I would still want to expose this as say a contrib module
> binary instead of hacking it into postgres.  It would be our first server
> program entry there.
>
>
Sorry for self-reply but:

Maybe name it "pg_script_check" with a, for now mandatory, "--syntax-only"
option that enables this raw parse mode.  Leaving room for executing this
in an environment where there is, or it can launch, a running instance that
then performs post-parse analysis as well.

David J.