proposal: plpgsql pragma statement
От | Pavel Stehule |
---|---|
Тема | proposal: plpgsql pragma statement |
Дата | |
Msg-id | CAFj8pRALJQnTbvc-Vt-5Lni8C8CtRS0S249hqN9=so+6bmhyqQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: proposal: plpgsql pragma statement
Re: proposal: plpgsql pragma statement Re: proposal: plpgsql pragma statement |
Список | pgsql-hackers |
Hi
I wrote plpgsql_check https://github.com/okbob/plpgsql_check.
It is working well, but because it does static analyse only, sometimes it can produces false alarms or it should to stop a analyse, because there are not necessary data.
I see one possible solution in introduction of pragma statement with syntax:
PRAGMA keyword [content to semicolon];
The pragma has a relation to following statement. So the issue 36 can be solved by pragma
PRAGMA cmdtype CREATE;
EXECUTE format('CREATE TABLE xxx ...
The PRAGMA statement does nothing in runtime. It works only in compile time, and add a pair of key, value to next non pragma statement. This information can be used by some plpgsql extensions.
What do you think about this proposal?
Regards
Pavel
В списке pgsql-hackers по дате отправления: