I try
update table_a set trn_no = table_b.trn_no from table_a,table_bwhere table_a.cust_no=table_b.cust_no
IN pgsql 7.0x IS OK
if run 7.1 IS error ??