Re: proposal: plpgsql pragma statement

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: proposal: plpgsql pragma statement
Дата
Msg-id CAFj8pRDQUM=vvNLSUdwSUanbBvsFJQz3n82ZZBFss=Cce1z8Sg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: proposal: plpgsql pragma statement  (Pavel Luzanov <p.luzanov@postgrespro.ru>)
Список 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 though about it, but it is significantly harder for implementation. Now, the content of comments are just ignored. If we push PRAGMA into comments, then we should to do some work with comments.

PRAGMA as statement is much more easy for implementation. But Using PRAGMA inside comments is very good alternative.

Regards

Pavel

 
 
-----
Pavel Luzanov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


		
	


	

					

					





	

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

	
	

		
			

	        	

	       			Предыдущее
	    		

	    		
	От:
	Pavel Stehule

	Дата:
	



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

	    	

	    
	    
	    
			

	        	

	       			Следующее
	    		

	    		
	От:
	Julien Demoor

	Дата:
	



	Сообщение:
	Re: NOTIFY and pg_notify performance when deduplicating notifications