Opened 12 years ago
Closed 12 years ago
#289 closed defect (fixed)
Update sequence for table ps_crs in petascope creation query
Reported by: | 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
Note:
See TracTickets
for help on using tickets.
Fixed by changeset:5234991