NOTICE-message - Mailing list pgsql-general

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.mehlig@zmt.uni-bremen.de>
               Center for Tropical Marine Ecology/ZMT, Bremen, Germany
-----------------------------------------------------------------------