Postgres Pro
Downloads
Home   >   mailing lists

KeyError: self._index[x] - Mailing list pgsql-general

From tango ward
Subject KeyError: self._index[x]
Date
Msg-id CAA6wQLJGd-c8rqAetCrk4QMAqFGaX-dqTMVAc934PptvrKqVrg@mail.gmail.com
Whole thread Raw
Responses Re: KeyError: self._index[x]
List pgsql-general
Tree view
Good day,

Apologies for asking again.

I am trying to remove the whitespace on student number by using TRANSLATE() inside the execute() of psycopg2. Problem that I am getting is, even if I will just print the row with the column name(e.g. row['snumber']), I am getting KeyError error message. The code works if i will print the row with index value(e.g. row[0])

`
cur_p = conn_pr(cursor_factory=psycopg2.extras.DictCursor)
cur_t = conn_t.cursor(cursor_factory=psycopg2.extras.DictCursor)


cur_t.execute("""
                SELECT TRANSLATE(snumber, ' ', '')
                FROM sprofile """)

for row in cur_t:

`

pgsql-general by date:

Previous
From: tango ward
Date:
Subject: Re: psycopg2.DataError: invalid input syntax for integer: ""
Next
From: tango ward
Date:
Subject: Re: KeyError: self._index[x]