"Marshall, Steve" <smarshall@wsi.com> writes:
> There is a problem in PL/TCL that can cause the postgres backend to
> become multithreaded. Postgres is not designed to be multithreaded, so
> this causes downstream errors in signal handling. We have seen this
> cause a number of "unexpected state" errors associated with notification
> handling; however, unpredictable signal handling would be likely to
> cause other errors as well.
I've applied this patch to CVS HEAD (8.3-to-be). I'm a bit hesitant
to back-patch it however, at least not till it gets through some beta
testing.
Thanks for the detailed explanation, test case, and patch!
regards, tom lane