NOTICE-message

Hello postgreSQL folks,

when retrieving data from a join of two tables (one of them having
many columns, very bad designed ;-) I get the following "notice":

----------------------------------------------------------------------
[psql (PostgreSQL) 7.0.2
contains readline, history support. i386er Linux 2.2.16]

[...]
NOTICE: PortalHeapMemoryFree: 0x0x40b139c8 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x0x40b139c8 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x0x40b139c8 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x0x40b139c8 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x0x40b13f80 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x0x40b13f80 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x0x40b13f80 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x0x40b13f80 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x0x40b14538 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x0x40b14538 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x0x40b14538 not in alloc set!
[...]
----------------------------------------------------------------------

Something to worry about?

Regards, Ulf

P.S.: Here's the query, I hope that helps!

select s_id,nummer,
min(timest::time) as timest,
round(avg(photo),2),round(stddev(photo),3),
round(avg(trmmol),2),round(stddev(photo),3),
round(avg(pari),2),round(stddev(pari),2),
round(min(pari),2),round(max(pari),2),
round(avg(paro),2),round(stddev(paro),2),
round(min(paro),2), round(max(paro),2),
min(timest::date)-beobachtet_seit as ageInDays
from blatt,li64_daten
where dkopf_nummer=187 and
blatt_nummer=nummer and
not deakt
group by s_id,nummer,nummer,beobachtet_seit
order by 8,1,2,7;

BTW, looking at queries like that: Is there a possibility to
adhust the precision for displaying floating point numbers in
general, to reduce so many "rounds()"?

--
=======================================================================
Ulf Mehlig <ulf(dot)mehlig(at)zmt(dot)uni-bremen(dot)de>
Center for Tropical Marine Ecology/ZMT, Bremen, Germany
-----------------------------------------------------------------------