Re: plPGsql and PostgreSQL 7.1beta4 in Cygwin doesn't work

"Eduardo Stern" <eduardo(at)stern(dot)com(dot)br> writes:
> I've installed cygwin 1.1.8, with the latest snapshot with mmap corrections,
> installed cygipc, compiled PostgreSQL 7.1beta4. Made the regression test
> using make SHELL=/bin/bash check, ant it passed all 76 tests.

> Then I created a database for productions with initdb, created some tables,
> and tried a plpgsql function. It hangs the server everytime. Even a very
> small plpgsql function hangs. Tried createlang with the -L parameter, and it
> gives the same problem. The same plpgsql function works great on the Linux
> PostgreSQL.

Hm. There are tests of plpgsql in the regress tests, so it's not the
case that plpgsql is completely broken on your machine. Can you attach
to the backend process with gdb and get a backtrace to see where it's
hanging?

regards, tom lane