[mod_python] value too large for PgNumeric

Julio Mendoza jm at eemsystems.cjb.net
Wed Jun 25 13:04:20 EST 2003

this error:

File "/usr/lib/python2.2/site-packages/pyPgSQL/PgSQL.py", line 1335, in
    raise OverflowError, "value too large for PgNumeric"

is produced by this query:

"""select  q1.Area,q1.Prop_disponibles,q1.MinCompra,q1.MaxCompra,q1.MinAlquiler,q1.MaxAlquiler from (select  areas.descripcion as Area,count(*) as Prop_disponibles,min(coalesce(prop.precio_venta,0)) as MinCompra,max(coalesce(prop.precio_venta,0)) as MaxCompra,min(coalesce(prop.precio_alquiler,0)) as MinAlquiler,max(coalesce(prop.precio_alquiler,0)) as MaxAlquiler from propiedades prop, tipo_de_propiedades tdp,Sectores sector,areas where prop.tipo_de_propiedad_id = tdp.tipo_de_propiedad_id and sector.area_id = areas.area_id and prop.sector_area_id = sector.area_id and prop.sector_id = sector.sector_id and prop.propiedad_id in (select fot.propiedad_id from fotos fot where fot.propiedad_id = prop.propiedad_id) and current_date between prop.efectivo_desde and prop.efectivo_hasta and prop.activa = 'Y' and prop.tipo_de_propiedad_id=%s  group by areas.descripcion) as "q1"  order by q1.prop_disponibles desc limit 2;""" % (i[2])))

only for a few alternatives.

Any help? thanks.


Julio Mendoza <jm at eemsystems.cjb.net>

More information about the Mod_python mailing list