Hi Every Body, i'v declared my trigger function with plpgsql. there's problems with statements inside IF .. END IF block that not executed at all. i guess from plpgsql problem so i registering procedural language that more friendly to me, thereis plpython/plpythonu, but the problem rise again. this is illustration : J:\Program Files\PostgreSQL\8.1\bin>createlang -U postgres -d template1 plpythonu Error messages: createlang: language installation failed: ERROR: could not load library "J:/Pro gram Files/PostgreSQL/8.1/lib/plpython.dll": The specified module could not be f ound. my questions : 1. whats wrong with the trigger. 2. although the directory already exists, an error message "The specified module could not be f ound".raised when i registering pl, whats the problem? 3. thanks all. My Specs : - Win 2000 Advanced Server Powered NAS - Borland Delphi 7 - PGOleDB 1.0.0.19 - PostgreSQL 8.1.1 - Intel P4 2.4 GHz, 256 MB RAM. Send instant messages to your online friends http://uk.messenger.yahoo.com
