ThePL/Python procedural language allowsPostgreSQL functions to be written in thePython language.
The current version ofPL/Python functions as a trusted language only; access to the file system and other local resources is disabled. Specifically,PL/Python uses the Python restricted execution environment, further restricts it to prevent the use of the fileopen call, and allows only modules from a specific list to be imported. Presently, that list includes: array, bisect, binascii, calendar, cmath, codecs, errno, marshal, math, md5, mpz, operator, pcre, pickle, random, re, regex, sre, sha, string, StringIO, struct, time, whrandom, and zlib.
In the current version, any database error encountered while running aPL/Python function will result in the immediate termination of that function by the server. It is not possible to trap error conditions using Pythontry ... catch constructs. For example, a syntax error in an SQL statement passed to theplpy.execute() call will terminate the function. This behavior may be changed in a future release.