SELECT queries are not working, however INSERT works

[MathiasG-2159628]

        select_query = "SELECT * from rri"
        res = connection.cursor().execute(select_query)
        result_rows = connection.cursor().fetchall()

After using the following query , I receive the error: psycopg2.ProgrammingError: no results to fetch. However there are clearly records present in the database table.

Insert operations work just fine.

   insert_query = "INSERT INTO rri (timestamp, ms) VALUES (%s, %s)"
    connection.cursor().execute(insert_query, (timestamp, ms))
    connection.commit()

I really appreciate if someone can reach out because I'm at my wit's end.

[MathiasG-2159628]

solved: needed to assign connection.cursor() to a variable:

connection = psycopg2.connect(**db_params)
    cur = connection.cursor()
    cur.execute('SELECT * FROM rri;')

    rows = cur.fetchall()
    connection.commit()
    connection.close()