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  (Alexey Bashtanov <bashtanov@imap.cc>)
Re: proposal: plpgsql pragma statement  (Dmitry Igrishin <dmitigr@gmail.com>)
Re: proposal: plpgsql pragma statement  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Hi


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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: psql display of foreign keys