Re: proposal: plpgsql pragma statement

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: proposal: plpgsql pragma statement
Дата
Msg-id CAFj8pRAzaL+Uh9i5_GR+YEHcnmNyvKvuo4OnoM-Stj2pxV5Q9w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: proposal: plpgsql pragma statement  (Alexey Bashtanov <bashtanov@imap.cc>)
Список pgsql-hackers


st 5. 12. 2018 v 14:42 odesílatel Alexey Bashtanov <bashtanov@imap.cc> napsal:


You can use PERFORM as a workaround:

PERFORM 'PRAGMA', 'cmdtype', 'CREATE';

There's some overhead when executing, but probably not too much.

Thank you for tip, but I have not any idea, how it can work?


Well, I thought you were for a comment-like thing that remains there when compiled and can act as a hint for your static analysis extension.
Surely this PERFORM won't impose any hints on the following statement itself.
But maybe your extension could read the PERFORM statement preceding it and treat it as an annotation hint for the following statement.

PERFORM is +/- SELECT, so if I use PERFORM, I have to modify this statement.



Best,
  Alex

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

Предыдущее
От: Pavel Luzanov
Дата:
Сообщение: Re: proposal: plpgsql pragma statement
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal: plpgsql pragma statement