CODEWITHSUNDEEP
pythonpostgresqlpsycopg2
darksky
darksky

Reputation: 21059

psycopg2 INSERT INTO execute not returning result

I am inserting an item the usual way using cursor's execute. However, doing a cursor.fetchone() afterwards throws a ProgrammaticError saying no results could be fetched. I can see the item inserted into the database.

What is the issue here? I am opening a connection with a with statement, and I am not calling commit as this is taken care of in the with statement.

Is there a way to retrieve the result that was just inserted into psycopg2 easily?

Upvotes: 1

Views: 1452

Answers (1)

Wolph
Wolph

Reputation: 80111

Most likely you didn't add a RETURNING *; to your INSERT statement.

So... try something like this:

INSERT INTO table
...
RETURNING *;

Upvotes: 4

Related Questions