Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id B856D9FB693
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Sat,  9 Jun 2007 14:22:01 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 17095-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Sat,  9 Jun 2007 14:21:58 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.242])
	by postgresql.org (Postfix) with ESMTP id 3EFC59FB66B
	for <pgsql-sql@postgresql.org>; Sat,  9 Jun 2007 14:21:58 -0300 (ADT)
Received: by an-out-0708.google.com with SMTP id c36so730753ana
	for <pgsql-sql@postgresql.org>; Sat, 09 Jun 2007 10:21:57 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=gi1DegM+QtS8tUTAWALldZCiFipAbIhTLJ0I1/Womf5AhJANrT8dr2o0ccXjSTztSVPXP/R1oxK2A2tEoMEkX1KZGN4KbstvGpqfh3Q4jeb+H178IAuX9tyS94I1ajMXPHZeKSJhwZsZIzDdo25whDfGO6Nhf9W7nacp1bPtkZQ=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=M70mo9yjF0uO2MrvDfrzojnYwtcA2086Eq7WAKyqa127Md1U8Y9C1t2RwkzzX/VOtyN6j7sfshnHRj504+5K9Llq9FXlKqSZtzXdxXRVoOZNWc3AsrjwJ/5JhBCJqmPLwrf4jnN/Ec3WqbT5jzXxzhWPltpl/zSaiwbHbJPdjfQ=
Received: by 10.100.165.9 with SMTP id n9mr2425583ane.1181409717419;
	Sat, 09 Jun 2007 10:21:57 -0700 (PDT)
Received: by 10.100.173.9 with HTTP; Sat, 9 Jun 2007 10:21:57 -0700 (PDT)
Message-ID: <bf54be870706091021q1659922cj9bea80a36c81c5c7@mail.gmail.com>
Date: Sat, 9 Jun 2007 13:21:57 -0400
From: "Shoaib Mir" <shoaibmir@gmail.com>
To: "chester c young" <chestercyoung@yahoo.com>
Subject: Re: search path within trigger
Cc: "sql pgsql" <pgsql-sql@postgresql.org>
In-Reply-To: <488965.30548.qm@web54306.mail.re2.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_92451_13862891.1181409717396"
References: <488965.30548.qm@web54306.mail.re2.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/79
X-Sequence-Number: 28569

------=_Part_92451_13862891.1181409717396
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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
>

------=_Part_92451_13862891.1181409717396
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Did you try &#39;select current_schema&#39; ?<br><br>--<br>Shoaib Mir<br>EnterpriseDB (<a href="http://www.enterprisedb.com">www.enterprisedb.com</a>)<br><br><div><span class="gmail_quote">On 6/9/07, <b class="gmail_sendername">
chester c young</b> &lt;<a href="mailto:chestercyoung@yahoo.com">chestercyoung@yahoo.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
within a table pl/pgsql trigger, what&#39;s the easiest way to see if the<br>schema for the triggered table is the same as search_path?<br><br><br><br>____________________________________________________________________________________
<br>Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.<br><a href="http://answers.yahoo.com/dir/?link=list&amp;sid=396545469">http://answers.yahoo.com/dir/?link=list&amp;sid=396545469
</a><br><br>---------------------------(end of broadcast)---------------------------<br>TIP 6: explain analyze is your friend<br></blockquote></div><br>

------=_Part_92451_13862891.1181409717396--