X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 945D647580B
	for <pgsql-sql@postgresql.org>; Thu, 27 Mar 2003 19:59:43 -0500 (EST)
Received: from mail2.tpgi.com.au (mail.tpgi.com.au [203.12.160.58])
	by postgresql.org (Postfix) with ESMTP id 0A501474E44
	for <pgsql-sql@postgresql.org>; Thu, 27 Mar 2003 19:59:42 -0500 (EST)
Received: from jac (bri-ts1-2600-039.tpgi.com.au [203.219.24.39])
	by mail2.tpgi.com.au (8.11.6/8.11.6) with SMTP id h2S0xhs10429;
	Fri, 28 Mar 2003 11:59:43 +1100
Message-ID: <004501c2f4c5$5116f970$1400a8c0@jac>
From: "jack" <datactrl@tpg.com.au>
To: <pgsql-sql@postgresql.org>, "Ian Barwick" <barwick@gmx.net>
References: <000f01c2f403$c6fc7bf0$1400a8c0@jac>
	<200303271111.24745.barwick@gmx.net>
Subject: Re: EXECUTE problem on schema
Date: Fri, 28 Mar 2003 10:59:40 +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=-7.5 required=5.0
	tests=BAYES_30,REFERENCES,UPPERCASE_25_50
	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/622
X-Sequence-Number: 12660

Ian,

Sorry about the version mistake. It's V7.3.2. And the following are the
example.

Jack

CREATE TABLE test_j2(
 c1 varchar (2),
 n2 integer,
PRIMARY KEY(c1, n2)
);
/*
a1 100
b1 200
*/

/*
Calling tesp_test1 with 'test_j2' is ok, while calling with 'public.test_j2'
will fail.

*/

CREATE OR REPLACE FUNCTION tesP_test1( NAME) RETURNS INTEGER AS'
BEGIN

 EXECUTE
  ''UPDATE ''||quote_ident($1)||'' SET n2 = 1'';
 RETURN 0;

END;'
 LANGUAGE 'PLPGSQL';