Setting global vars for use with triggers

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Setting global vars for use with triggers
Date: 2005-06-22 20:36:20
Message-ID: 20050622203621.48806.qmail@web52904.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-06-22 20:39:15 Re: [HACKERS] [PATCHES] Removing Kerberos 4
Previous Message David Mitchell 2005-06-22 20:31:56 Vacuum advice