Hi,
I'm getting odd behavior. The proxy function is only inserting SOME values into the table. Otherwise,the operation
worksfine when the JDBC client is connecting directly to the function in the database, bypassing the proxy function.
Here's the plroxy function call on the database "my_proxy";
CREATE OR REPLACE FUNCTION proxy_function.f_one (
bigint,
varchar(255),
int,
out did_insert bool
) AS
$$
cluster 'uds';
run on 0;
$$
language plproxy
strict security invoker;
And here's the invoked function on the database "mydatabase".
CREATE OR REPLACE FUNCTION proxy_function.f_one (
IN id_val bigint,
IN name_val character varying(255),
IN carrier_id_in integer,
OUT did_insert boolean
) AS
$$
BEGIN
did_insert := false;
if not exists(select id from mytable where id=id_val) then
begin
insert into mytable (id, name, carrier_id) values (id_val, name_val, carrier_id_in);
did_insert := true;
end;
end if;
END;
$$
LANGUAGE PLPGSQL
VOLATILE
STRICT SECURITY DEFINER;
I'd appreciate any insight.
Thanks
Robert