Problem in psycopg2?

Question

Python

cursor.execute(f"SELECT id FROM property WHERE id = {member.id} and server_id = {server}")
psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block
What could be the problem?

Answer 1

The problem is that the previous request ended with an error and the transaction must be rolled back, or the construction with with must be used, then the transaction will be automatically rolled back if an error
occurs https://www.psycopg.org/docs/connection.html#conne...

conn = psycopg2.connect(DSN)

with conn:
    with conn.cursor() as curs:
        curs.execute(SQL1)

conn.close()