Opened 5 years ago

Closed 5 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:

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 Changed 5 years ago by dmisev

  • Resolution set to fixed
  • Status changed from new to closed
Note: See TracTickets for help on using tickets.