[web2py] Error in DAL when creating indexes in web2py 2.0.6 with PostgreSQL

[Juan Diego Romero González]

Hi. I'm having this error since I update to 2.0.2 when executing 
executesql()
<class 'psycopg2.ProgrammingError'> no results to fetch

7201.
7202.
7203.
7204.
7205.
7206.

7207.
7208.
7209.
7210.

            # will hold our finished resultset in a list
            data = adapter.cursor.fetchall()
            # convert the list for each row into a dictionary so it's
            # easier to work with. row['field_name'] rather than row[0]
            return [dict(zip(fields,row)) for row in data]
        data = adapter.cursor.fetchall()

        if fields:
            if not isinstance(fields, list):
                fields = [fields]
            extracted_fields = []

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.

# -*- coding: utf-8 -*-

db.define_table('banks',
    Field <http://web2py.glados/examples/global/vars/Field>('abm_number', 
'integer', length=3, notnull=True),
    Field <http://web2py.glados/examples/global/vars/Field>('institution_name', 
'string', notnull=True),
    Field <http://web2py.glados/examples/global/vars/Field>('short_name', 
'string', notnull=True),
    format='%(short_name)s'
)

db.executesql('CREATE INDEX idx_banks_name ON banks (abm_number, 
(upper(short_name)));')

I've fixed it adding a try for the statement in line 10 but why am I 
getting this error? I don't think that's how it is supposed to work, of 
maybe it is for PostgreSQL. 

Thanks in advance :)

J.

--