Calling stored procredure from psycopg2 - Mailing list psycopg

From Graeme Gemmill
Subject Calling stored procredure from psycopg2
Date
Msg-id b820ec88-fe89-0551-a1a5-8d992b8fc26a@gemmill.name
Whole thread Raw
Responses Re: Calling stored procredure from psycopg2
Re: Calling stored procredure from psycopg2
List 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 by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: [psycopg] 2.7.2 still problem with readonly/autocommit, was:Changing set_session implementation
Next
From: David Fetter
Date:
Subject: Re: Calling stored procredure from psycopg2