diff options
| author | Daniele Varrazzo <daniele.varrazzo@gmail.com> | 2021-05-20 14:13:00 +0200 |
|---|---|---|
| committer | Daniele Varrazzo <daniele.varrazzo@gmail.com> | 2021-05-20 14:13:19 +0200 |
| commit | 263ace6657195776addcce66fab6e16b68fc39e3 (patch) | |
| tree | 11ab79ee8b483f139320d3c1ce5e95dd8360b0db | |
| parent | 7479e6b31e6ed520c9db3814623629ef49e79932 (diff) | |
| download | psycopg2-263ace6657195776addcce66fab6e16b68fc39e3.tar.gz | |
Add note about cursor.callproc() and PostgreSQL procedures
Close #1155
| -rw-r--r-- | doc/src/cursor.rst | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/doc/src/cursor.rst b/doc/src/cursor.rst index 78db03f..ad0e74b 100644 --- a/doc/src/cursor.rst +++ b/doc/src/cursor.rst @@ -232,6 +232,16 @@ The ``cursor`` class .. versionchanged:: 2.7 added support for named arguments. + .. note:: + + `!callproc()` can only be used with PostgreSQL functions__, not + with the procedures__ introduced in PostgreSQL 11, which require + the :sql:`CALL` statement to run. Please use a normal + `execute()` to run them. + + .. __: https://www.postgresql.org/docs/current/sql-createfunction.html + .. __: https://www.postgresql.org/docs/current/sql-createprocedure.html + .. method:: mogrify(operation [, parameters]) Return a query string after arguments binding. The string returned is |