title: Postgresql table update
body: <p>I updated a database table using postgresql from python
  My code was </p>
  
  <pre><code>import psycopg2
  connection=psycopg2.connect("dbname=homedb user=ria")
  cursor=connection.cursor()
  l_dict= {'licence_id':1}
  cursor.execute("SELECT * FROM im_entry.usr_table")
  rows=cursor.fetchall()
  
  for row in rows:
     i=i+1
     p = findmax(row)
     #print p
     idn="id"
     idn=idn+str(i)
  
  
     cursor.execute("UPDATE im_entry.pr_table SET (selected_entry) = ('"+p+"') WHERE  image_1d ='"+idn+"'")
     print 'DATABASE TO PRINT'
  cursor.execute("SELECT * FROM im_entry.pr_table")
  rows=cursor.fetchall()
  for row in rows:
      print row   
  </code></pre>
  
  <p>I got the updated table displayed</p>
  
  <p>But when i display updated table by psql as
  homedb=# SELECT * FROM im_entry.pr_table; 
  i got an empty table displayed..what is wrong?? please help me </p>