error.expected 1.37 KB
Newer Older
Bruce Momjian's avatar
Bruce Momjian committed
1
SELECT invalid_type_uncaught('rick');
2
NOTICE:  plpython: in function __plpython_procedure_invalid_type_uncaught_49801:
Bruce Momjian's avatar
Bruce Momjian committed
3 4
plpy.SPIError: Cache lookup for type `test' failed.
SELECT invalid_type_caught('rick');
5 6
NOTICE:  plpython: in function __plpython_procedure_invalid_type_caught_49802:
plpy.SPIError: Cache lookup for type `test' failed.
Bruce Momjian's avatar
Bruce Momjian committed
7
SELECT invalid_type_reraised('rick');
8 9
NOTICE:  plpython: in function __plpython_procedure_invalid_type_reraised_49803:
plpy.SPIError: Cache lookup for type `test' failed.
Bruce Momjian's avatar
Bruce Momjian committed
10 11 12 13 14 15
SELECT valid_type('rick');
 valid_type 
------------
 
(1 row)

16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
SELECT read_file('/etc/passwd');
ERROR:  plpython: Call of function `__plpython_procedure_read_file_49809' failed.
exceptions.IOError: can't open files in restricted mode
SELECT write_file('/tmp/plpython','This is very bad');
ERROR:  plpython: Call of function `__plpython_procedure_write_file_49810' failed.
exceptions.IOError: can't open files in restricted mode
SELECT getpid();
ERROR:  plpython: Call of function `__plpython_procedure_getpid_49811' failed.
exceptions.AttributeError: getpid
SELECT uname();
ERROR:  plpython: Call of function `__plpython_procedure_uname_49812' failed.
exceptions.AttributeError: uname
SELECT sys_exit();
ERROR:  plpython: Call of function `__plpython_procedure_sys_exit_49813' failed.
exceptions.AttributeError: exit
SELECT sys_argv();
    sys_argv    
----------------
 ['RESTRICTED']
(1 row)