Postgres Pro
Downloads
Home   >   mailing lists

Re: Dynamic prepare possible in plpgsql? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Dynamic prepare possible in plpgsql?
Date
Msg-id 27835.1178171718@sss.pgh.pa.us
Whole thread Raw
In response to Re: Dynamic prepare possible in plpgsql?  ("Collin Peters" <cadiolis@gmail.com>)
List pgsql-sql
Tree view 
"Collin Peters" <cadiolis@gmail.com> writes:
> So if I have an INSERT inside a LOOP in a plpgsql function, it is only
> prepared once?

Once per session, yes (barring some special cases like polymorphic
functions and trigger functions, which would get prepared once per
session per calling situation)
        regards, tom lane

pgsql-sql by date:

Previous
From: "Penchalaiah P."
Date:
Subject: Needs Function
Next
From: "Rodrigo De León"
Date:
Subject: Re: Needs Function