Thread: stored procedure code
Hi=2C I would like to learn about how stored procedures are handled in post= gres. In particular=2C I'd like to learn how plpgsql procedures are compile= d and stored=2C and how they (both plpgsql and C procedures) interact with = the optimizer during planning. Would appreciate if someone can point out so= me links to the source code for me to check out. Thanks!Derek =
On 02/23/2013 02:49 PM, Derek Perak wrote: > Hi, I would like to learn about how stored procedures are handled in > postgres. In particular, I'd like to learn how plpgsql procedures are > compiled and stored, and how they (both plpgsql and C procedures) > interact with the optimizer during planning. Would appreciate if someone > can point out some links to the source code for me to check out. A brief intro: http://www.postgresql.org/docs/9.2/interactive/plhandler.html A graphical look at the source code: http://www.postgresql.org/developer/backend/ If you click on the index link you get: http://wiki.postgresql.org/wiki/Backend_flowchart > > Thanks! > Derek -- Adrian Klaver adrian.klaver@gmail.com