PostgreSQL function card in the For loop

select * from scm_main.fn_connection_stations(1219646)

Print the message “Start…” but not the message “…End”.

CREATE OR REPLACE FUNCTION 
scm_main.fn_connection_stations(var_connection_id bigint)
RETURNS SETOF scm_main.typ_connection_stations AS
$BODY$DECLARE 
 var_affected INTEGER DEFAULT 0; 
 var_row scm_main.typ_connection_stations%ROWTYPE; 
BEGIN 
 RAISE NOTICE'Start.. .'; 
 FOR var_row IN 
 SELECT DISTINCT v.vbvdata_station_id
 FROM scm_main.tbl_vbvdata AS v 
 INNER JOIN scm_main.tbl_packet AS p ON (v.vbvdata_packet_id = 
 p.packet_id and p.packet_connection_id = var_connection_id) 
 --WHERE v.vbvdata_packet_id IN 
 --( SELECT packet_id FROM scm_main.tbl_packet AS o_p WHERE 
 o_p.packet_connection_id = var_connection_id) 
 LOOP 
 RETURN NEXT var_row; 
 END LOOP; 
 RAISE NOTICE'...End'; 
 RETURN; 
END 
$BODY$
 LANGUAGE plpgsql STABLE STRICT
 COST 100< br /> ROWS 1000;
ALTER FUNCTION scm_main.fn_connection_stations(bigint)
 OWNER TO postgres;

The query itself is very simple and runs when it is called directly, as shown below:< /p>

SELECT DISTINCT v.vbvdata_station_id 
FROM scm_main.tbl_vbvdata AS v 
INNER JOIN scm_main.tbl_packet AS p ON (v.vbvdata_packet_id = 
p .packet_id and p.packet_connection_id = 1219646)

I think the problem must be the locking of the table. But I absolutely don’t understand the reason and the problem that can be solved.

Some time ago, the comment section It was working. But after a while, the same problem appeared. I solved it by changing the query and replacing the condition with inner joins (cascading queries). But none of them worked this time!

Update

I made it work again with a stupid change:

INNER JOIN scm_main.tbl_packet AS p ON (v .vbvdata_packet_id = p.packet_id 
 and p.packet_connection_id = var_connection_id)`

Change to:

INNER JOIN scm_main.tbl_packet AS p ON (v.vbvdata_packet_id = p.packet_id)
 where p.packet_connection_id in (select var_connection_id)

and works very well.

Another interesting point is that even The following changes did not work and still hang:

INNER JOIN scm_main.tbl_packet AS p ON (v.vbvdata_packet_id = p.packet_id) 
 where p .packet_connection_id = var_connection_id

Now I found the solution. But I want to know how it happened!