Problem creating topology on pgrouting about osm2pgrouting HOT 2 OPEN

Recommended reading:

• pgRouting/pgrouting#2255
• https://docs.pgrouting.org/dev/en/pgr_extractVertices.html#create-a-routing-topology
  Using this method of creating the topology the user in in charge of creating appropriate indexes to the tables.
  Please if this new method works for you add a comment here:
  pgRouting/pgrouting#2308

from osm2pgrouting.

I try to follow the instruction in the https://docs.pgrouting.org/dev/en/pgr_extractVertices.html#create-a-routing-topology page:

NOTES:

1. to drop the vertices table imported with osm2pgrouting DROP TABLE IF EXISTS vertices_table; I need to drop constrains:

ALTER TABLE edge_table DROP CONSTRAINT ways_target_fkey;
ALTER TABLE edge_table DROP CONSTRAINT ways_target_osm_fkey;
ALTER TABLE edge_table DROP CONSTRAINT ways_source_fkey;
ALTER TABLE edge_table DROP CONSTRAINT ways_source_osm_fkey;

2. --Create the vertices table seems to works not correctly:
   Updated Rows 34701 (not selected !!)

In fact

SELECT  * FROM pgr_extractVertices(
  'SELECT gid, the_geom AS geom FROM edge_table',
  dryrun => true); 

extract 0 row

and

select * from vertices_table;

the result is the following:

in_edges and out_edges are null

Finally

WITH
out_going AS (
  SELECT id AS vid, unnest(out_edges) AS eid, x, y
  FROM vertices_table
)
UPDATE edge_table
SET source = vid, x1 = x, y1 = y
FROM out_going WHERE gid = eid;

--> Updated Rows 0

from osm2pgrouting.