Calling stored procredure from psycopg2
От | Graeme Gemmill |
---|---|
Тема | Calling stored procredure from psycopg2 |
Дата | |
Msg-id | b820ec88-fe89-0551-a1a5-8d992b8fc26a@gemmill.name обсуждение исходный текст |
Ответы |
Re: Calling stored procredure from psycopg2
Re: Calling stored procredure from psycopg2 |
Список | 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
В списке psycopg по дате отправления: