aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2014-11-01 11:31:35 -0400
committerPeter Eisentraut <peter_e@gmx.net>2014-11-01 11:33:48 -0400
commit615f6790d8fac2920eb88a6458768796e45a1020 (patch)
tree54110b65777fbe26609d954ff1af9afeb97cb8fd
parent38cb8687a9dde85b1dad3d347ab420ecdf2259b7 (diff)
downloadpostgresql-615f6790d8fac2920eb88a6458768796e45a1020.tar.gz
postgresql-615f6790d8fac2920eb88a6458768796e45a1020.zip
PL/Python: Fix example
Revert "6f6b46c9c0ca3d96acbebc5499c32ee6369e1eec", which was broken. Reported-by: Jonathan Rogers <jrogers@socialserve.com>
-rw-r--r--doc/src/sgml/plpython.sgml6
1 files changed, 5 insertions, 1 deletions
diff --git a/doc/src/sgml/plpython.sgml b/doc/src/sgml/plpython.sgml
index c15188c3e00..b8bf5e925cb 100644
--- a/doc/src/sgml/plpython.sgml
+++ b/doc/src/sgml/plpython.sgml
@@ -1023,7 +1023,11 @@ rv = plpy.execute(plan, ["name"], 5)
<xref linkend="plpython-sharing">). For example:
<programlisting>
CREATE FUNCTION usesavedplan() RETURNS trigger AS $$
- plan = SD.setdefault("plan", plpy.prepare("SELECT 1"))
+ if "plan" in SD:
+ plan = SD["plan"]
+ else:
+ plan = plpy.prepare("SELECT 1")
+ SD["plan"] = plan
# rest of function
$$ LANGUAGE plpythonu;
</programlisting>