connectivity issues
От | robert7390@comcast.net |
---|---|
Тема | connectivity issues |
Дата | |
Msg-id | 206574116.836821275862733501.JavaMail.root@sz0163a.emeryville.ca.mail.comcast.net обсуждение исходный текст |
Список | pgsql-jdbc |
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
В списке pgsql-jdbc по дате отправления: