X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B767447580B for ; Thu, 27 Mar 2003 05:12:13 -0500 (EST) Received: from post.webmailer.de (natsmtp01.webmailer.de [192.67.198.81]) by postgresql.org (Postfix) with ESMTP id EB83B47580B for ; Thu, 27 Mar 2003 05:12:02 -0500 (EST) Received: from ianb.local (pD9E0EB9D.dip.t-dialin.net [217.224.235.157]) by post.webmailer.de (8.12.8/8.8.7) with ESMTP id h2RAC2Ct022418; Thu, 27 Mar 2003 11:12:03 +0100 (MET) Content-Type: text/plain; charset="iso-8859-1" From: Ian Barwick To: "jack" , Subject: Re: EXECUTE problem on schema Date: Thu, 27 Mar 2003 11:11:24 +0100 X-Mailer: KMail [version 1.4] References: <000f01c2f403$c6fc7bf0$1400a8c0@jac> In-Reply-To: <000f01c2f403$c6fc7bf0$1400a8c0@jac> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200303271111.24745.barwick@gmx.net> X-Spam-Status: No, hits=-26.8 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,RCVD_IN_NJABL, RCVD_IN_OSIRUSOFT_COM,REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/613 X-Sequence-Number: 12651 On Thursday 27 March 2003 02:54, jack wrote: > Hi, all > > postgreSQL v7.3.3 Are you sure? The latest release is 7.3.2. > I found EXECUTE on pl/pgsql doesn't support schema. When I specify a table > such as "public.tablename", it reported "not such a relation object". The > only SQL statement I used is "update". Don't know wether other statements > have the same problem. Can you post an example? Ian Barwick barwick@gmx.net