Hi,
I read a few lines about SP compilation in postgres
http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci1179016,00.html
I read a few lines about SP compilation in postgres
http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci1179016,00.html
1. stored procedure compilation is transactional.
"You can recompile a stored procedure on a live system,
and only transactions starting after that compilation will see the
changes," he said. "Transactions in process can complete with the old
version. Oracle just blocks on the busy procedure."
Is this what the Transactional DDL feature of postgresql talks about ?
Thanks
~Harpreet
Thanks
~Harpreet