Re: stored procedure code - Mailing list pgsql-general

From Adrian Klaver
Subject Re: stored procedure code
Date
Msg-id 51294CD3.1080104@gmail.com
Whole thread Raw
In response to stored procedure code  (Derek Perak <derekperak@hotmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Derek Perak
Date:
Subject: stored procedure code
Next
From: Maz Mohammadi
Date:
Subject: Re: [JDBC] can't access through SSL