--

-- Unicode error handling

--

CREATE FUNCTION unicode_return_error() RETURNS text AS '

CREATE FUNCTION unicode_return_error() RETURNS text ASE'

return u"\\x80"

' LANGUAGE plpythonu;

CREATE FUNCTION unicode_trigger_error() RETURNS trigger AS '

CREATE FUNCTION unicode_trigger_error() RETURNS trigger ASE'

TD["new"]["testvalue"] = u"\\x80"

return "MODIFY"

' LANGUAGE plpythonu;

CREATE TRIGGER unicode_test_bi BEFORE INSERT ON unicode_test

FOR EACH ROW EXECUTE PROCEDURE unicode_trigger_error();

CREATE FUNCTION unicode_plan_error1() RETURNS text AS '

CREATE FUNCTION unicode_plan_error1() RETURNS text ASE'

plan = plpy.prepare("SELECT $1 AS testvalue", ["text"])

rv = plpy.execute(plan, [u"\\x80"], 1)

return rv[0]["testvalue"]

' LANGUAGE plpythonu;

CREATE FUNCTION unicode_plan_error2() RETURNS text AS '

CREATE FUNCTION unicode_plan_error2() RETURNS text ASE'

plan = plpy.prepare("SELECT $1 AS testvalue1, $2 AS testvalue2", ["text", "text"])

rv = plpy.execute(plan, u"\\x80", 1)

return rv[0]["testvalue1"]

CREATEFUNCTIONunicode_return_error() RETURNStextAS'

CREATEFUNCTIONunicode_return_error() RETURNStextASE'

' LANGUAGE plpythonu;

CREATEFUNCTIONunicode_trigger_error() RETURNS triggerAS'

CREATEFUNCTIONunicode_trigger_error() RETURNS triggerASE'

' LANGUAGE plpythonu;

CREATETRIGGERunicode_test_bi BEFORE INSERTON unicode_test

FOR EACH ROW EXECUTE PROCEDURE unicode_trigger_error();

CREATEFUNCTIONunicode_plan_error1() RETURNStextAS'

CREATEFUNCTIONunicode_plan_error1() RETURNStextASE'

' LANGUAGE plpythonu;

CREATEFUNCTIONunicode_plan_error2() RETURNStextAS'

CREATEFUNCTIONunicode_plan_error2() RETURNStextASE'