Re: [GENERAL] Setting global vars for use with triggers

2005-06-22 Thread Michael Fuhr
On Wed, Jun 22, 2005 at 01:36:20PM -0700, CSN wrote: > > I'd like to create a trigger which deletes associated > files whenever their corresponding row is deleted. I looked at the thread you posted and saw that you were considering using LISTEN/NOTIFY. That's probably a good idea because if you d

Re: [GENERAL] Setting global vars for use with triggers

2005-06-22 Thread Douglas McNaught
CSN <[EMAIL PROTECTED]> writes: > 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 wh

[GENERAL] Setting global vars for use with triggers

2005-06-22 Thread CSN
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 usin