Re: updating a view

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