summaryrefslogtreecommitdiff
path: root/src/pl/plpython/sql/plpython_error.sql
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2009-08-24 20:25:25 +0000
committerPeter Eisentraut <peter_e@gmx.net>2009-08-24 20:25:25 +0000
commit5dff93638c4443d3afba017f64c9ade69e0fbd3b (patch)
treef3d9c7456f569a2b68dc7e3227485d15c0d358dc /src/pl/plpython/sql/plpython_error.sql
parent8bed238c871fae205c5c6615f3b9ab8a039359e2 (diff)
Make PL/Python tests more compatible with Python 3
This changes a bunch of incidentially used constructs in the PL/Python regression tests to equivalent constructs in cases where Python 3 no longer supports the old syntax. Support for older Python versions is unchanged.
Diffstat (limited to 'src/pl/plpython/sql/plpython_error.sql')
-rw-r--r--src/pl/plpython/sql/plpython_error.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/src/pl/plpython/sql/plpython_error.sql b/src/pl/plpython/sql/plpython_error.sql
index 04161bc25ec..5ca68495be0 100644
--- a/src/pl/plpython/sql/plpython_error.sql
+++ b/src/pl/plpython/sql/plpython_error.sql
@@ -37,7 +37,7 @@ SELECT exception_index_invalid_nested();
*/
CREATE FUNCTION invalid_type_uncaught(a text) RETURNS text
AS
-'if not SD.has_key("plan"):
+'if "plan" not in SD:
q = "SELECT fname FROM users WHERE lname = $1"
SD["plan"] = plpy.prepare(q, [ "test" ])
rv = plpy.execute(SD["plan"], [ a ])
@@ -55,7 +55,7 @@ SELECT invalid_type_uncaught('rick');
*/
CREATE FUNCTION invalid_type_caught(a text) RETURNS text
AS
-'if not SD.has_key("plan"):
+'if "plan" not in SD:
q = "SELECT fname FROM users WHERE lname = $1"
try:
SD["plan"] = plpy.prepare(q, [ "test" ])
@@ -77,7 +77,7 @@ SELECT invalid_type_caught('rick');
*/
CREATE FUNCTION invalid_type_reraised(a text) RETURNS text
AS
-'if not SD.has_key("plan"):
+'if "plan" not in SD:
q = "SELECT fname FROM users WHERE lname = $1"
try:
SD["plan"] = plpy.prepare(q, [ "test" ])
@@ -97,7 +97,7 @@ SELECT invalid_type_reraised('rick');
*/
CREATE FUNCTION valid_type(a text) RETURNS text
AS
-'if not SD.has_key("plan"):
+'if "plan" not in SD:
SD["plan"] = plpy.prepare("SELECT fname FROM users WHERE lname = $1", [ "text" ])
rv = plpy.execute(SD["plan"], [ a ])
if len(rv):