Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 152B89FB295 for ; Sat, 9 Jun 2007 14:09:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 34214-09 for ; Sat, 9 Jun 2007 14:09:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54306.mail.re2.yahoo.com (web54306.mail.re2.yahoo.com [206.190.49.116]) by postgresql.org (Postfix) with SMTP id 2A4659FB293 for ; Sat, 9 Jun 2007 14:09:34 -0300 (ADT) Received: (qmail 38933 invoked by uid 60001); 9 Jun 2007 16:56:58 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=fZzwyPKubJyIARFXwwkm99l7yM00+swFi3fYH7KHLuOqh7h6632HwLrfcSCQ5pBDLxsXHfi8cU71wC0BlIYAJFCVmUNNMNRkiDRaorsqNi3rVKwhyEkFZceN7mZJTqgeYu1aKv3RU7R8sY2tg4Bb5seFI25qDgcuLbRr9dUXZgs=; X-YMail-OSG: 3f0mdJQVM1knLWEz0xBb_oKA0yEJCeeD_AW8YTi4bqoASbT_idNX4kHNN.ypFsZ1JhEdyk2.TX7MQBOzIQ66hwWNv8Kh3qpiOd_O5PbhfmnXXKbuAUTQr_f1Drw7IWP4dQLKjL9rHkC7NX27lUR4Eh6n Received: from [75.23.137.206] by web54306.mail.re2.yahoo.com via HTTP; Sat, 09 Jun 2007 09:56:58 PDT Date: Sat, 9 Jun 2007 09:56:58 -0700 (PDT) From: chester c young Subject: search path within trigger To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <488965.30548.qm@web54306.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/78 X-Sequence-Number: 28568 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