Why is the permissions request not being fulfilled?

Question

Python

Executing a script with psycopg2 connected

import psycopg2
self.conn = psycopg2.connect(_conn_string)
self.cursor = self.conn.cursor()
self.cursor.execute('GRANT SELECT, INSERT ON TABLE log_fields TO manager;')

gives the error "ERROR: current transaction aborted, commands until the end of the transaction block are ignored"

Answer 1

You can find out the details of the error, for example, like this:

try:
    self.cursor.execute('GRANT SELECT, INSERT ON TABLE log_fields TO manager;')
except psycopg2.Error as e:
    print(e.pgerror)
    print(e.diag.message_primary)
    print(psycopg2.errorcodes.lookup(e.pgcode))