From: | Graeme <graeme(at)gemmill(dot)name> |
---|---|
To: | psycopg(at)lists(dot)postgresql(dot)org |
Subject: | Re: Calling stored procredure from psycopg2 |
Date: | 2018-01-24 17:48:28 |
Message-ID: | 4031ceda-274f-da7a-3cb9-b3c4f23d530d@gemmill.name |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | psycopg |
Ed, Rory: thank you for replying. However, I do not think the postgresql
'search_path' is involved. I used psql to input the function, display
the search path
show search_path;
search_path
-----------------
"$user", public
and \df to confirm its presence:
Schema | Name |
public | search_columns | etc
I still get
psycopg2.ProgrammingError: function search_columns(unknown) does not
exist. (Yes, I did restart the server)
Furthermore, I didn't have to do anything in the Mageia 5 environment to
install search.sql, just copied it to the same directory as the main
Python routine.
The search routine I use is copied from
https://stackoverflow.com/questions/5350088/how-to-search-a-specific-value-in-all-tables-postgresql/39473673
Furthermore:
In the Mageia 5 implementation, the psql command:
contacts=# select * from search_columns('Clarke');
produces the correct response. The Mageia 6 implementation produces the
error message:
ERROR: function search_columns(unknown) does not exist
Regards to all,
Graeme
From | Date | Subject | |
---|---|---|---|
Next Message | Daniele Varrazzo | 2018-01-24 18:22:00 | Re: Calling stored procredure from psycopg2 |
Previous Message | Rory Campbell-Lange | 2018-01-23 17:54:27 | Re: Calling stored procredure from psycopg2 |