RelationClearRelation: relation X deleted while still in use???

I seem to be getting some bogus "RelationClearRelation: relation
2678605 deleted while still in use" errors.  Has anyone seen this
before?  This is with only one process running and after a fresh
vacuum.  I can fix it by re-running the vacuum and then rerunning
the query.  It seems to be random as sometimes but not always I
can simply re-run the query without doing a vacuum and it works
fine the second time.

I'd be happy to hear about a workaround or maybe even a fix.

I have PostgreSQL 7.2.1 running under Solaris 8 on an Intel box.
The database is moderate size, on order 100K rows in some tables.
I can't seem to reproduce the error with anything less then my
full 10K lines of code application.


Here is an Excerpt from my program's log file.  It first
prints the error returned from the back end and them prints
the SQL it sent.

ERROR SQL command failed:
ERROR:  RelationClearRelation: relation 2678605 deleted while still in
use

ERROR SQL Statment that failed:
  select count(location.sequence)
    from location, measurement, format, vehicle
    where
      measurement.name   = 'WWB001N'   AND
      vehicle.project         = '401'  AND
      vehicle.vehicle         = '001'  AND
      vehicle.rev             = 'T'    AND
      format.format_type      = 'VEHCENTAUR' AND
      location.measurement_id = measurement.measurement_id AND
      measurement.format_id   = format.format_id           AND
      format.vehicle_id       = vehicle.vehicle_id;



=====
Chris Albertson
  Home:   310-376-1029  chrisalbertson90278@yahoo.com
  Cell:   310-990-7550
  Office: 310-336-5189  Christopher.J.Albertson@aero.org

__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com