|
| 1 | +-- test error handling, i forgot to restore Warn_restart in |
| 2 | +-- the trigger handler once. the errors and subsequent core dump were |
| 3 | +-- interesting. |
| 4 | +SELECT invalid_type_uncaught('rick'); |
| 5 | +WARNING: plpython: in function invalid_type_uncaught: |
| 6 | +DETAIL: plpy.SPIError: Unknown error in PLy_spi_prepare |
| 7 | +ERROR: type "test" does not exist |
| 8 | +SELECT invalid_type_caught('rick'); |
| 9 | +WARNING: plpython: in function invalid_type_caught: |
| 10 | +DETAIL: plpy.SPIError: Unknown error in PLy_spi_prepare |
| 11 | +ERROR: type "test" does not exist |
| 12 | +SELECT invalid_type_reraised('rick'); |
| 13 | +WARNING: plpython: in function invalid_type_reraised: |
| 14 | +DETAIL: plpy.SPIError: Unknown error in PLy_spi_prepare |
| 15 | +ERROR: type "test" does not exist |
| 16 | +SELECT valid_type('rick'); |
| 17 | + valid_type |
| 18 | +------------ |
| 19 | + |
| 20 | +(1 row) |
| 21 | + |
| 22 | +-- |
| 23 | +-- Test Unicode error handling. |
| 24 | +-- |
| 25 | +SELECT unicode_return_error(); |
| 26 | +ERROR: plpython: function "unicode_return_error" could not create return value |
| 27 | +DETAIL: exceptions.UnicodeEncodeError: 'ascii' codec can't encode character '\u80' in position 0: ordinal not in range(128) |
| 28 | +INSERT INTO unicode_test (testvalue) VALUES ('test'); |
| 29 | +ERROR: plpython: function "unicode_trigger_error" could not modify tuple |
| 30 | +DETAIL: exceptions.UnicodeEncodeError: 'ascii' codec can't encode character '\u80' in position 0: ordinal not in range(128) |
| 31 | +SELECT unicode_plan_error1(); |
| 32 | +WARNING: plpython: in function unicode_plan_error1: |
| 33 | +DETAIL: plpy.Error: Unknown error in PLy_spi_execute_plan |
| 34 | +ERROR: plpython: function "unicode_plan_error1" could not execute plan |
| 35 | +DETAIL: exceptions.UnicodeEncodeError: 'ascii' codec can't encode character '\u80' in position 0: ordinal not in range(128) |
| 36 | +SELECT unicode_plan_error2(); |
| 37 | +ERROR: plpython: function "unicode_plan_error2" could not execute plan |
| 38 | +DETAIL: exceptions.UnicodeEncodeError: 'ascii' codec can't encode character '\u80' in position 0: ordinal not in range(128) |