Re: updating a view - Mailing list pgsql-general

From Tom Lane
Subject Re: updating a view
Date
Msg-id 583.1166149420@sss.pgh.pa.us
Whole thread Raw
In response to Re: updating a view  (m.c.wilkins@massey.ac.nz)
Responses Re: updating a view  (m.c.wilkins@massey.ac.nz)
List pgsql-general
m.c.wilkins@massey.ac.nz writes:
> so maybe i'm using the word crash too liberally.  this is the error
> message i get:

> server closed the connection unexpectedly

Looks like a crash to me.

> version is 8.2.0, just downloaded a few days ago.

There's a known bug in 8.2.0 having to do with failing out of a
subtransaction, which would include a plperlu spi_exec() to a query
that gets an error.  So I'm thinking that might be what you're hitting.
If you built from source, you could apply this patch:
http://archives.postgresql.org/pgsql-committers/2006-12/msg00063.php

            regards, tom lane

pgsql-general by date:

Previous
From: m.c.wilkins@massey.ac.nz
Date:
Subject: Re: updating a view
Next
From: Peter Koczan
Date:
Subject: Re: A few SQL questions