Re: proposal: plpgsql pragma statement
| От | Pavel Stehule |
|---|---|
| Тема | Re: proposal: plpgsql pragma statement |
| Дата | |
| Msg-id | CAFj8pRC-H5qGjw7DqoU0shYXXJ+C+i4eN00gZ_XsjkAD9LfjuA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: proposal: plpgsql pragma statement (Pavel Luzanov <p.luzanov@postgrespro.ru>) |
| Ответы |
Re: proposal: plpgsql pragma statement
|
| Список | pgsql-hackers |
st 5. 12. 2018 v 15:03 odesílatel Pavel Luzanov <p.luzanov@postgrespro.ru> napsal:
But maybe your extension could read the PERFORM statement preceding it and treat it as an annotation hint for the following statement.
In this case, comment line in some format will be better than real PERFORM statement. Like this:
/*+PRAGMA cmdtype CREATE; */
EXECUTE format('CREATE TABLE xxx ...
I looked there and It is not possible to implement it - plpgsql uses SQL lexer, and the content of comments are just ignored. So I cannot to read comments. There is not any possibility to read it simply from plpgsql. Unfortunately, but it is expected, there is nothing like query string for plpgsql statement.
Regards
Pavel
----- Pavel Luzanov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
В списке pgsql-hackers по дате отправления: