From: | "Shoaib Mir" <shoaibmir(at)gmail(dot)com> |
---|---|
To: | "chester c young" <chestercyoung(at)yahoo(dot)com> |
Cc: | "sql pgsql" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: search path within trigger |
Date: | 2007-06-09 17:21:57 |
Message-ID: | bf54be870706091021q1659922cj9bea80a36c81c5c7@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Did you try 'select current_schema' ?
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/9/07, chester c young <chestercyoung(at)yahoo(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kristo Kaiv | 2007-06-11 06:28:13 | Re: show index from [table] |
Previous Message | chester c young | 2007-06-09 16:56:58 | search path within trigger |