Re: stored procedure code

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(dot)klaver(at)gmail(dot)com