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  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Список 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 по дате отправления:
	
	

	
	

		
			

	        	

	       			Предыдущее
	    		

	    		
	От:
	Alvaro Herrera

	Дата:
	



	Сообщение:
	Re: don't mark indexes invalid unnecessarily
 

	    	

	    
	    
	    
			

	        	

	       			Следующее
	    		

	    		
	От:
	"Jonah H. Harris"

	Дата:
	



	Сообщение:
	Re: proposal: plpgsql pragma statement