Postgres Pro
Downloads
Home   >   mailing lists

Thread: search path within trigger

search path within trigger

From
chester c young
Date:
within a table pl/pgsql trigger, what's the easiest way to see if the
schema for the triggered table is the same as search_path?

      
____________________________________________________________________________________
Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469

Re: search path within trigger

From
"Shoaib Mir"
Date:
Did you try 'select current_schema' ?

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 6/9/07, chester c young <chestercyoung@yahoo.com> wrote:
within a table pl/pgsql trigger, what's the easiest way to see if the
schema for the triggered table is the same as search_path?



____________________________________________________________________________________
Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend