Re: PortalHeapMemoryFree...in diskless client

Tom Lane wrote:

> Karla Peralta <karlaper(at)elrosado(dot)com> writes:
> >> A bug with symptoms similar to this was fixed in 7.0.3. Please
> >> try 7.0.3, and let us know if you still have problems.
>
> > Now I'm using postgresql-7.0.3-2 but I have the same problem.
>
> Oh well :-(
>
> > What else can i do ????
>
> Show us a sequence of queries that causes these messages, and we'll
> fix it ...
>
> regards, tom lane

The messages show ups in two queries

This is the first query:

select
cod_alma,direccion,nom_alma,nomc_alma,ruc,ciudad,autoriza,que_precio,
cotizacion,ban_cierre,fech_pro
from tab_alma;

This is the structure:

Table "tab_alma"
Attribute | Type | Modifier
------------+-------------+----------
cod_alma | varchar(2) |
nom_alma | varchar(40) |
cta_cont | varchar(6) |
clase_alma | varchar(1) |
nomc_alma | varchar(10) |
ruc | varchar(14) |
ciudad | varchar(15) |
cant_ubic | float8 |
cant_emis | float8 |
cotizacion | float8 |
dia_libre | varchar(1) |
fech_pant | date |
fech_pro | date |
fech_corte | date |
es_corte | boolean |
ban_cierre | boolean |
corte_luz | boolean |
que_precio | varchar(1) |
autoriza | boolean |
clave_vta | varchar(6) |
clave_iva | varchar(6) |
direccion | varchar(40) |
bco_socied | varchar(6) |
bco_contin | varchar(6) |
impto_rta | varchar(6) |
secuen_aud | float8 |
tiket | varchar(6) |
tiket_dev | varchar(6) |
tiket_nul | varchar(6) |
cup_tarjf | varchar(2) |
Index: itab_alma

This is the second query:

select posicion,tipo,ind_micro,ini_dia,ind_tiket
from scr_usua where login_i='" +LogIni+"';

This is the structure:

Table "scr_usua"
Attribute | Type | Modifier
------------+-------------+----------
login_i | varchar(10) |
nom_usua | varchar(30) |
estacion | varchar(12) |
tipo | varchar(1) |
tiket | varchar(6) |
zeta | varchar(4) |
ini_dia | boolean |
fech_ini | date |
hora_ini | varchar(10) |
fech_cie | date |
hora_cie | varchar(10) |
ind_x | boolean |
ind_z | boolean |
ind_estado | boolean |
ind_pago | boolean |
ind_reci | boolean |
ind_tiket | boolean |
cla_tiket | varchar(1) |
tike_nulo | varchar(6) |
tike_pdte | varchar(6) |
ind_txc | boolean |
clave | varchar(13) |
emi_anu | boolean |
emi_dev | boolean |
emi_dscto | boolean |
emi_cre | boolean |
emi_tar | boolean |
emi_ant | boolean |
emi_gto | boolean |
emi_pro | boolean |
posicion | varchar(3) |
ind_micro | boolean |
tiket_dev | varchar(6) |
tiket_rec | varchar(6) |
tiket_nul | varchar(6) |
Indices: iscr_usu1,
iscr_usua

Regards,

Karla