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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [PATCH] Add --syntax to postgres for SQL syntax checking
Дата
Msg-id CAKFQuwa9MeRz=tJDmzKS=NdVVAbEx=E1GgJeMUfmf10OMBHqyQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PATCH] Add --syntax to postgres for SQL syntax checking  (Josef Šimánek <josef.simanek@gmail.com>)
Ответы Re: [PATCH] Add --syntax to postgres for SQL syntax checking  (Josef Šimánek <josef.simanek@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
On Fri, Dec 15, 2023 at 8:05 AM Josef Šimánek <josef.simanek@gmail.com> wrote:
pá 15. 12. 2023 v 15:50 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:
>
> Laurenz Albe <laurenz.albe@cybertec.at> writes:
> > 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?
>
> This seems like a fairly useless wart to me.  What does it do that
> you can't do better with existing facilities (psql etc)?

Per my experience, this is mostly useful during development to catch
syntax errors super early.

I'd suggest helping this project get production capable since it already is trying to integrate with the development ecosystem you describe here.

https://github.com/supabase/postgres_lsp

I agree that developing this as a new executable for the purpose is needed in order to best conform to existing conventions.

David J.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Josef Šimánek
Дата:
Сообщение: Re: [PATCH] Add --syntax to postgres for SQL syntax checking
Следующее
От: Josef Šimánek
Дата:
Сообщение: Re: [PATCH] Add --syntax to postgres for SQL syntax checking