ya'da man tom! applied the patch, rebuilt, and postgres doesn't crash anymore. fixed my syntax error, and all is working properly. phew, my first experience with sql.... thanks! matt On Thu, Dec 14, 2006 at 09:23:40PM -0500, Tom Lane wrote: > m.c.wilkins@xxxxxxxxxxxx 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
