PostgreSQL存储过程移植方法

Transplanting stored procedure from Oracle to PostgreSQL

在对PostgreSQL存储过程处理机制进行研究的基础上,分析了Oracle存储过程移植到PostgreSQL时的语法、参数默认值、out参数、事务回滚、游标和内置函数等问题,并从成本、收益和技术难度的角度比较了两种存储过程移植方法——改写存储过程方法和扩展PostgreSQL的存储过程功能方法。深入研究了通过扩展PL/pgSQL源码来调整PostgreSQL存储过程功能的PLSE方法。

Based on researching into process mechanism of stored procedures in PostgreSQL, main problems in transporting Oracle＇ s stored procedures to PostgreSQL were analyzed, including syntax, parameter default, out parameters, rollback, cursor, and inline functions, etc. From the point of view of cost, return on investment and technique difficulty, two transplanting manners of stored procedures, rewriting stored procedures itself and extending the function of PostgreSQL stored procedures were compared. The PLSE, which is a transplantation solution that the function of PostgreSQL stored procedures is adjusted through extending PL/pgSQL source codes, was investigated.