Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.1.1 backend crashes on updates to very large text columns - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.1.1 backend crashes on updates to very large text columns
Date
Msg-id 17649.991110800@sss.pgh.pa.us
Whole thread Raw
In response to 7.1.1 backend crashes on updates to very large text columns  ("Norman J. Clarke" <norman@combimatrix.com>)
Responses Re: 7.1.1 backend crashes on updates to very large text columns  ("Norman J. Clarke" <norman@combimatrix.com>)
List pgsql-general
Tree view 
"Norman J. Clarke" <norman@combimatrix.com> writes:
> However, on update to the larger (100k+)columns, the postgres backend
> crashes and dumps core. I've included a backtrace from the core file.

This looks entirely irrelevant to either TOAST or update; I think it is
the known 7.1.1 bug with SELECTs that return no rows in plpgsql.
Try 7.1.2.

            regards, tom lane

pgsql-general by date:

Previous
From: "Tim Barnard"
Date:
Subject: Re: [SQL] Difficult SQL Statement
Next
From: "Eric G. Miller"
Date:
Subject: Re: incomplete transaction keeps table locked?