From: jack <datactrl@tpg.com.au>
To: pgsql-sql@postgresql.org
To: Ian Barwick <barwick@gmx.net>
Subject: Re: EXECUTE problem on schema
Date: Fri, 28 Mar 2003 10:59:40 +1000
Message-ID: <004501c2f4c5$5116f970$1400a8c0@jac> (raw)
References: <000f01c2f403$c6fc7bf0$1400a8c0@jac>
<200303271111.24745.barwick@gmx.net>
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';
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: datactrl@tpg.com.au, barwick@gmx.net
Subject: Re: EXECUTE problem on schema
In-Reply-To: <004501c2f4c5$5116f970$1400a8c0@jac>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox