X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CACC5475CBC for ; Wed, 26 Mar 2003 20:54:18 -0500 (EST) Received: from mail2.tpgi.com.au (mail.tpgi.com.au [203.12.160.58]) by postgresql.org (Postfix) with ESMTP id 4480C47580B for ; Wed, 26 Mar 2003 20:54:17 -0500 (EST) Received: from jac (bri-ts4-2600-210.tpgi.com.au [203.219.27.210]) by mail2.tpgi.com.au (8.11.6/8.11.6) with SMTP id h2R1sIJ08637 for ; Thu, 27 Mar 2003 12:54:19 +1100 Message-ID: <000f01c2f403$c6fc7bf0$1400a8c0@jac> From: "jack" To: Subject: EXECUTE problem on schema Date: Thu, 27 Mar 2003 11:54:15 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Spam-Status: No, hits=-1.6 required=5.0 tests=BAYES_30 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/597 X-Sequence-Number: 12635 Hi, all postgreSQL v7.3.3 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. Jack