Opened 11 years ago

Closed 6 years ago

#2080 closed defect (wontfix)

CopyTopology fails to set layer sequence

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 2.5.0
Component: topology Version: 2.0.x
Keywords: Cc:

Description

After running CopyTopology against a topology with one layer, adding another layer (AddTopoGeometryColumn) fails with : 

ERROR:  duplicate key value violates unique constraint "layer_pkey"

I suspect this is due to a failure in updating the layer_id sequence.

If I recall correctly a testcase was found to fail but we hushed it down. Robe, remember ? It was about 9.1 doing something differently with sequences… I'm indeed running 9.1 now.

Change History (9)

comment:1 by strk, 11 years ago

Found: #1970

comment:2 by strk, 11 years ago

Milestone: PostGIS 2.0.2 → PostGIS 2.0.3

comment:3 by pramsey, 11 years ago

Milestone: PostGIS 2.0.4 → PostGIS 2.0.5

comment:4 by pramsey, 10 years ago

Milestone: PostGIS 2.0.5 → PostGIS 2.0.6

comment:5 by pramsey, 9 years ago

Milestone: PostGIS 2.0.7 → PostGIS 2.0.8

comment:6 by pramsey, 7 years ago

Milestone: PostGIS 2.0.8 → PostGIS 2.2.6

comment:7 by pramsey, 7 years ago

Milestone: PostGIS 2.2.6 → PostGIS 2.2.7

comment:8 by robe, 6 years ago

Milestone: PostGIS 2.2.7 → PostGIS 2.5.0

comment:9 by robe, 6 years ago

Resolution: → wontfix
Status: new → closed

You know 6 years is a long time to not care. I'm just dismissing this. too lazy to check if it's still an issue.

Note: See TracTickets for help on using tickets.