| PostgreSQL 9.6.0 锟街诧拷
| |||
|---|---|---|---|
| 锟斤拷一页 | 锟斤拷一锟斤拷 | 锟斤拷 44. PL/Python - Python 锟斤拷锟斤拷锟斤拷锟斤拷 | 锟斤拷一页 |
plpy模锟斤拷也锟结供锟剿猴拷锟斤拷
| plpy.debug(msg, **kwargs) |
| plpy.log(msg, **kwargs) |
| plpy.info(msg, **kwargs) |
| plpy.notice(msg, **kwargs) |
| plpy.warning(msg, **kwargs) |
| plpy.error(msg, **kwargs) |
| plpy.fatal(msg, **kwargs) |
plpy.error锟斤拷plpy.fatal实锟斤拷锟较伙拷锟斤拷锟揭伙拷锟� Python 锟届常锟斤拷锟斤拷锟矫伙拷锟斤拷锟阶斤拷锟斤拷锟斤拷锟斤拷岜伙拷锟斤拷锟斤拷锟斤拷锟斤拷貌锟窖拷械锟斤拷碌锟角帮拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷止锟斤拷raise plpy.Error(msg)锟斤拷raise plpy.Fatal(msg)锟街憋拷锟叫э拷诘锟斤拷锟�plpy.error(msg)锟斤拷plpy.fatal(msg)锟斤拷锟斤拷锟斤拷raise锟斤拷式锟斤拷锟斤拷锟斤拷锟斤拷锟捷关硷拷锟绞诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷只锟斤拷锟缴诧拷同锟斤拷锟饺硷拷锟斤拷锟斤拷息锟斤拷一锟斤拷锟截讹拷锟斤拷锟饺硷拷锟斤拷锟斤拷息锟角憋拷锟斤拷锟斤拷锟斤拷突锟斤拷恕锟叫达拷锟斤拷锟斤拷锟斤拷锟斤拷志锟斤拷锟斤拷锟斤拷锟竭讹拷锟斤拷锟斤拷锟斤拷log_min_messages锟斤拷client_min_messages锟斤拷锟矫憋拷锟斤拷锟斤拷锟狡★拷锟斤拷锟�锟斤拷 19 锟斤拷锟斤拷
msg锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷位一锟斤拷位锟矫诧拷锟斤拷锟斤拷为锟斤拷锟斤拷锟斤拷锟捷ｏ拷锟斤拷锟皆革拷锟斤拷锟斤拷锟斤拷一锟斤拷位锟矫诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷拢锟� 位锟矫诧拷锟斤拷锟轿成碉拷元锟斤拷锟斤拷址锟斤拷锟斤拷锟斤拷锝拷锟斤拷杀锟斤拷锟斤拷锟酵伙拷锟剿碉拷锟斤拷息锟斤拷
锟斤拷锟斤拷 keyword-only 锟斤拷锟斤拷锟结被锟斤拷锟杰ｏ拷
| detail |
| hint |
| sqlstate |
| schema_name |
| table_name |
| column_name |
| datatype_name |
| constraint_name |
CREATE FUNCTION raise_custom_exception() RETURNS void AS $$
plpy.error("custom exception message",
detail="some info about exception",
hint="hint for users")
$$ LANGUAGE plpythonu;
=# SELECT raise_custom_exception();
ERROR: plpy.Error: custom exception message
DETAIL: some info about exception
HINT: hint for users
CONTEXT: Traceback (most recent call last):
PL/Python function "raise_custom_exception", line 4, in <module>
hint="hint for users")
PL/Python function "raise_custom_exception"
锟斤拷一锟介工锟竭猴拷锟斤拷锟斤拷plpy.quote_literal(string)锟斤拷plpy.quote_nullable(string)锟皆硷拷plpy.quote_ident(string)锟斤拷锟斤拷锟角碉拷效锟斤拷锟斤拷 9.4 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟节斤拷锟斤拷锟矫猴拷锟斤拷锟斤拷锟节癸拷锟斤拷锟斤拷时锟斤拷询时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫筹拷锟斤拷锟斤拷 41-1锟叫讹拷态 SQL 锟斤拷 PL/Python 锟斤拷效锟斤拷锟角ｏ拷
plpy.execute("UPDATE tbl SET %s = %s WHERE key = %s" % (
plpy.quote_ident(colname),
plpy.quote_nullable(newvalue),
plpy.quote_literal(keyvalue)))