Opened 12 years ago

Closed 12 years ago

#289 closed defect (fixed)

Update sequence for table ps_crs in petascope creation query

Reported by: barboni@… Owned by: abeccati
Priority: minor Milestone: 8.4
Component: petascope Version: 8.3
Keywords: Cc:
Complexity: Medium

Description

Ticket moved from EarthServer track http://212.201.49.163/trac/ticket/111 as suggested by Alan

Hello
I have found a small issue that affect petascope database and can raise an exception in postgresql:
'duplicate key value violates unique constraint "ps_crs_pkey"'

In my opinion the following query in "/applications/petascope/src/main/db/petascope/update0.sql" should be uncommented

— SELECT pg_catalog.setval('ps_crs_id_seq', 9, true);

The table ps_crs is no longer a static table.

Ciao
Damiano

Change History (1)

comment:1 by Dimitar Misev, 12 years ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.