triggers in latest snapshot
От | Keith Woodell |
---|---|
Тема | triggers in latest snapshot |
Дата | |
Msg-id | DAEPLOBLGHIGDDNJMMOKCELCCJAA.efesar@unm.edu обсуждение исходный текст |
Ответ на | Re: win32 pgsql not installable (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | pgsql-hackers-win32 |
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
В списке pgsql-hackers-win32 по дате отправления: