I've compiled the 8.2.0 sources from
http://www.postgresql.org/ftp/source/v8.2/
and when run, it crash by logging the same messages.
I'll compile from the nightly snapshot tarball (which is probably 8.3 ?) and
will post
the result.
Jean-Pierre Pelletier
>From: Alvaro Herrera <alvherre@commandprompt.com>
>To: JEAN-PIERRE PELLETIER <pelletier_32@sympatico.ca>
>CC: pgsql-bugs@postgresql.org
>Subject: Re: [BUGS] server process exited with exit code -1073741819 on 8.2
>Windows
>Date: Wed, 20 Dec 2006 15:31:11 -0300
>
>JEAN-PIERRE PELLETIER wrote:
>
> > I just upgraded to PostgreSQL 8.2 and have a function
> > which crashes PostgreSQL 8.2 while logging these messages:
> >
> > server process exited with exit code -1073741819
> > terminating any other active server processes
>
>There was an SPI bug which may explain your problem, fixed after 8.2 was
>released. This is the fix:
>
>http://archives.postgresql.org/pgsql-committers/2006-12/msg00063.php
>
>Not sure how you could get a patched version short of compiling it
>yourself. Or you could wait for 8.2.1.
>
>--
>Alvaro Herrera http://www.CommandPrompt.com/
>The PostgreSQL Company - Command Prompt, Inc.