You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am using pgr_nodeNetwork('edges', 0.001, 'id', 'geom', 'noded', '', f) to create the paths network. Since the table is being re-generated multiple times the value of old_id in resulting table have cross integer limit and is giving error
Where: SQL statement "INSERT INTO public."edges_node_network" (old_id,sub_id,geom) ( WITH cut_locations AS
org.postgresql.util.PSQLException: ERROR: integer out of range
I am generating a new table as partition every time and later on attaching it to the parent table. I have changed the datatype of old_id as bigint in parent table but while generating new one it's giving integer out of range error. How to solve this?
Also, how is this old_id generated, many times I have noticed it remains unchanged if we execute the pgr_nodeNetwork multiple times.
Below is the example of table generated with old_id as integer. I have printed the column_name and it's type for the resulting table.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I am using
pgr_nodeNetwork('edges', 0.001, 'id', 'geom', 'noded', '', f)
to create the paths network. Since the table is being re-generated multiple times the value of old_id in resulting table have cross integer limit and is giving errorI am generating a new table as partition every time and later on attaching it to the parent table. I have changed the datatype of
old_id
as bigint in parent table but while generating new one it's giving integer out of range error. How to solve this?Also, how is this old_id generated, many times I have noticed it remains unchanged if we execute the
pgr_nodeNetwork
multiple times.Below is the example of table generated with
old_id
as integer. I have printed the column_name and it's type for the resulting table.Beta Was this translation helpful? Give feedback.
All reactions