Re: bug ? updates and insert crash the backend

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