I may have discovered a bug in the latest Win32 snapshots. I wanted to let
you all know just in case this is not already being covered. If you need
information like crash dumps, database schema, etc etc etc, let me know.
I cannot run any trigger functions (pgplsql) that involve SELECT, INSERT,
UPDATE or DELETE. The postgres backend that's handling the request crashes
hard, though the main postmaster continues to run and handle requests. It
happens regardless of the frontend (PGAdmin III, PHP) and it's consistent
and reproducible.
A simple trigger function like this crashes it:
BEGIN
SELECT NULL;
END;
One other note, triggers run fine on the 7.4 production running on FreeBSD,
with the same data and database schema.
-Keith Woodell
System Administrator
Natural Heritage New Mexico
505-277-3822 ext 232, 505-277-3844 (fax)
Please report NHNM technical support issues at http://admin.heritage.unm.edu