| From: | Josef Šimánek <josef(dot)simanek(at)gmail(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: [PATCH] Add --syntax to postgres for SQL syntax checking |
| Date: | 2023-12-15 13:14:11 |
| Message-ID: | CAFp7QwqFO9YiXCXUNX8dHWHkBmKT5-Q3Qa1D4OnvnPBYCYZtWA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Dne pá 15. 12. 2023 14:09 uživatel Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
napsal:
> On Fri, 2023-12-15 at 13:21 +0100, Josef Šimánek wrote:
> > Inspired by Simon Riggs' keynote talk at PGCounf.eu 2023 sharing list
> > of ideas for PostgreSQL
> > (https://riggs.business/blog/f/postgresql-todo-2023) I have crafted a
> > quick patch to do SQL syntax validation.
> >
> > What do you think?
>
> I like the idea. But what will happen if the SQL statement references
> tables or other objects, since we have no database?
>
It checks just the identifier is valid from parser perspective, like it is
valid table name.
> Yours,
> Laurenz Albe
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2023-12-15 13:19:07 | Re: [PATCH] Add --syntax to postgres for SQL syntax checking |
| Previous Message | hubert depesz lubaczewski | 2023-12-15 13:10:58 | Re: pgBufferUsage.blk_{read|write}_time are zero although there are pgBufferUsage.local_blks_{read|written} |