diff options
| author | Daniele Varrazzo <daniele.varrazzo@gmail.com> | 2021-05-20 14:13:00 +0200 |
|---|---|---|
| committer | Daniele Varrazzo <daniele.varrazzo@gmail.com> | 2021-06-16 16:51:13 +0100 |
| commit | c5aa98d8bcddcaea15c25f0e90aa2b918e3732c0 (patch) | |
| tree | 0fea12ddab4163fc9086e3bea5008d45e797faa8 | |
| parent | cbbf195a23ce3eee03e6523e8c11046e5d1227c4 (diff) | |
| download | psycopg2-c5aa98d8bcddcaea15c25f0e90aa2b918e3732c0.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 2123b17..b3e3b42 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 |