Setting global vars for use with triggers - Mailing list pgsql-general

From CSN
Subject Setting global vars for use with triggers
Date
Msg-id 20050622203621.48806.qmail@web52904.mail.yahoo.com
Whole thread Raw
Responses Re: Setting global vars for use with triggers  (Douglas McNaught <doug@mcnaught.org>)
Re: Setting global vars for use with triggers  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: David Mitchell
Date:
Subject: Vacuum advice
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] [PATCHES] Removing Kerberos 4