Re: bug ? updates and insert crash the backend - Mailing list pgsql-general

From Tom Lane
Subject Re: bug ? updates and insert crash the backend
Date
Msg-id 22302.1046890902@sss.pgh.pa.us
Whole thread Raw
In response to bug ? updates and insert crash the backend  (Laurent Perez <downloader@free.fr>)
List pgsql-general
Laurent Perez <downloader@free.fr> writes:
> t2g_1=# explain verbose update tiers set num_siret='abcd' where
> num_tiers='33';
> message type 0x44 arrived from server while idle
> server closed the connection unexpectedly

This turns out to be a planner bug associated with inherited tables ---
7.3.* fails if an UPDATE or DELETE has an inherited target, and
additional inherited tables are used in the query.

The patch can be found at
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/optimizer/plan/planner.c
if anyone else needs it.

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: a date_part question
Next
From: Carlos Moreno
Date:
Subject: Re: Is It possible to fixe a table in mermory ?