--> --> -->
 
 
<class 'psycopg2.ProgrammingError'>
Python 2.7.9: /usr/bin/python
Fri Apr 3 21:18:32 2020

A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.

 /var/geobretagne/prod/graphe/hydrometrie_qmj.py in ()
    147 
    148 if re.match("^\w+$", cgi_code):
=>  149     identifiant, data = getData(cgi_code)
    150     getChart(identifiant, data)
    151 else:
identifiant undefined, data undefined, getData = <function getData>, cgi_code = 'J3834010'
 /var/geobretagne/prod/graphe/hydrometrie_qmj.py in getData(code_hydro='J3834010')
     70 
     71 
=>   72     cursor.execute(sql, {'code_hydro': code_hydro})
     73     rows = cursor.fetchall()
     74     conn.close()
cursor = <cursor object at 0x7f5ca5ce0528; closed: 0>, cursor.execute = <built-in method execute of psycopg2._psycopg.cursor object>, sql = '\nSELECT\n dreal_b.hydrometrie_qmj.identifiant,\n ..._ref.code_hydro=%(code_hydro)s\nORDER BY date ASC;', code_hydro = 'J3834010'

<class 'psycopg2.ProgrammingError'>: ERREUR: la colonne hydrometrie_qmj.code_hydro n'existe pas LINE 18: dreal_b.hydrometrie_qmj.code_hydro = dreal_b.hydrometrie_q... ^ HINT: Peut-être que vous souhaitiez référencer la colonne « hydrometrie_qmj.code_hydro_3 ».
      args = ('ERREUR: la colonne hydrometrie_qmj.code_hydro n...r la colonne \xc2\xab hydrometrie_qmj.code_hydro_3 \xc2\xbb.\n',)
      cursor = <cursor object at 0x7f5ca5ce0528; closed: 0>
      diag = <psycopg2._psycopg.Diagnostics object>
      message = 'ERREUR: la colonne hydrometrie_qmj.code_hydro n...r la colonne \xc2\xab hydrometrie_qmj.code_hydro_3 \xc2\xbb.\n'
      pgcode = '42703'
      pgerror = 'ERREUR: la colonne hydrometrie_qmj.code_hydro n...r la colonne \xc2\xab hydrometrie_qmj.code_hydro_3 \xc2\xbb.\n'