Re: Re[2]: Vacuudb problem - Mailing list pgsql-general

From Tom Lane
Subject Re: Re[2]: Vacuudb problem
Date
Msg-id 17733.989506381@sss.pgh.pa.us
Whole thread Raw
In response to Re[2]: Vacuudb problem  (Igor <dbmanager@osb368.nnov.ru>)
List pgsql-general
Igor <dbmanager@osb368.nnov.ru> writes:
> Sorry, I clean forgot to tell ....
> I'm running PG v7.02.

Ah.  Update to 7.0.3 (or even better 7.1, but 7.0.3 is a drop-in
replacement with no need for dump/reload).  I think you are getting
bit by a known bug in 7.0.2: if the client disconnects partway through
a transaction, the backend forgets to clean up before it exits.  That's
probably why you have these partially-removed temp tables laying about.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: GRANT
Next
From: Tony Grant
Date:
Subject: Re: ER diagrams