I'd like to create a trigger which deletes associated files whenever their corresponding row is deleted. Problem is, I don't want to hard-code directory locations in the trigger function. Is there a way to set a DOCUMENT_ROOT-like variable in Postgresql which triggers could access and use? I'm using PHP for the trigger (and PG 8.x). Thanks, CSN PS - Scott and I have been tossing around a few other ideas here: http://www.phpbuilder.com/board/showthread.php?s=&threadid=10302693 ____________________________________________________ Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly