Re: search path within trigger

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
>

In response to

Browse pgsql-sql by date

  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