| From: | Graeme Gemmill <graeme(at)gemmill(dot)name> |
|---|---|
| To: | psycopg(at)postgresql(dot)org |
| Subject: | Calling stored procredure from psycopg2 |
| Date: | 2018-01-23 14:00:57 |
| Message-ID: | b820ec88-fe89-0551-a1a5-8d992b8fc26a@gemmill.name |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | psycopg |
Environment is Mageia 5 x86_64, Python 3.4, Postgresql 9.3.20,
psycopg2-2.7.1
I have a working application that calls an external sql stored procedure
called search.sql with entry point "search_columns". I access it with
the statement self.cursor.callproc('search_columns', (target,))
I have moved that application to the following environment: Mageia 6
x86_64, Python 3.5, Postgresql 9.6.6, psycopg2-2.7.3.2. I now get an
error message:
psycopg2.ProgrammingError: function search_columns(unknown) does not exist
search.sql is in the same directory as other Python modules, so there
seems to have been a change in how to call stored sql procedures. Can
someone help please?
Thanks
Graeme
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2018-01-23 14:47:43 | Re: Calling stored procredure from psycopg2 |
| Previous Message | Karsten Hilbert | 2018-01-18 12:54:01 | Re: [psycopg] 2.7.2 still problem with readonly/autocommit, was: Changing set_session implementation |