Re: EXECUTE problem on schema

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';