Postgres Pro
Downloads
Home   >   mailing lists

Re: search path within trigger - Mailing list pgsql-sql

From Shoaib Mir
Subject Re: search path within trigger
Date
Msg-id bf54be870706091021q1659922cj9bea80a36c81c5c7@mail.gmail.com
Whole thread Raw
In response to search path within trigger  (chester c young <chestercyoung@yahoo.com>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: chester c young
Date:
Subject: search path within trigger
Next
From: Kristo Kaiv
Date:
Subject: Re: show index from [table]