Opened 7 years ago

Closed 12 months 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 Changed 7 years ago by strk

Found: #1970

comment:2 Changed 7 years ago by strk

Milestone: PostGIS 2.0.2PostGIS 2.0.3

comment:3 Changed 6 years ago by pramsey

Milestone: PostGIS 2.0.4PostGIS 2.0.5

comment:4 Changed 5 years ago by pramsey

Milestone: PostGIS 2.0.5PostGIS 2.0.6

comment:5 Changed 4 years ago by pramsey

Milestone: PostGIS 2.0.7PostGIS 2.0.8

comment:6 Changed 21 months ago by pramsey

Milestone: PostGIS 2.0.8PostGIS 2.2.6

comment:7 Changed 21 months ago by pramsey

Milestone: PostGIS 2.2.6PostGIS 2.2.7

comment:8 Changed 15 months ago by robe

Milestone: PostGIS 2.2.7PostGIS 2.5.0

comment:9 Changed 12 months ago by robe

Resolution: wontfix
Status: newclosed

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.