current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 4 down vote favorite
1

I'm trying to call a function from psycopg2 like such:

conn = psycopg2.connect(host="name.host.ex", user="username", password="secret")
cur = conn.cursor()
cur.callproc("f_do_action", ["aaa", "bbb"])
cur.close()
conn.close()

When calling this function from psql everything works fine but using psycopg2 nothing seems to happen. I get no exception. It just does not call out the function on the actual database.

Also other queries from psycopg2 work (SELECT, INSERT).

share|improve this question

1 Answer 1

up vote 11 down vote accepted

Try committing before closing your connection:

cur.close()
conn.commit()
conn.close()

From psycopg2 documentation:

Note that closing a connection without committing the changes first will cause any pending change to be discarded as if a ROLLBACK was performed (unless a different isolation level has been selected: see set_isolation_level()).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.