Re: Postgres crashed when adding a sequence column

From: Clive Page <cgp(at)star(dot)le(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres crashed when adding a sequence column
Date: 2005-01-19 13:50:00
Message-ID: Pine.LNX.4.44L0.0501191346320.3683-100000@peneca.star.le.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 19 Jan 2005, Richard Huxton wrote:

> Hmm - wonder if there might be some memory leak in updates to the R-tree
> - it gets used less than B-tree, so it could be. If you reply to this,
> make sure you mention your version of PG - one of the developers might
> know more. Probably also worth looking in the documentation for 8.0 and
> check the release notes section to see if any changes look applicable to
> your problem.

That's a possibility. I've now dropped all indices, and am trying again.

I forgot to post the version in use, it was 7.4.1 - will try to upgrade to
v8.0 soon, as it clearly solves another problem I encountered recently.
Thanks for all the help.

--
Clive Page
Dept of Physics & Astronomy,
University of Leicester, Tel +44 116 252 3551
Leicester, LE1 7RH, U.K. Fax +44 116 252 3311

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2005-01-19 13:57:47 Infinite recursion detected... How do I prevent that?
Previous Message John DeSoi 2005-01-19 13:43:14 pgEdit 1.0 Released