Laurent Perez <downloader(at)free(dot)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