Opened 3 years ago

Closed 3 years ago

#775 closed defect (fixed)

Add primary keys to petascopedb tables where not defined

Reported by: damiano Owned by: pcampalani
Priority: major Milestone: 9.0.x
Component: petascope Version: 9.0.0
Keywords: primary keys Cc: mantovani
Complexity: Easy

Description (last modified by pcampalani)

In petascopedb version 9
Eg. Table ps_vector_coefficients has no primary key.

Change History (6)

comment:1 Changed 3 years ago by dmisev

  • Milestone set to 9.0.x

comment:2 Changed 3 years ago by pcampalani

  • Description modified (diff)
  • Keywords primary keys added
  • Status changed from new to accepted
  • Summary changed from Primary key in ps_vector_coefficients TABLE to Add primary keys petascopedb where not defined

comment:3 Changed 3 years ago by pcampalani

  • Summary changed from Add primary keys petascopedb where not defined to Add primary keys to petascopedb tables where not defined

comment:4 Changed 3 years ago by pcampalani

So far no PK found in ps_vector_coefficients (WCS) and ps_servicelayer (old WMS schema).

petascopedb=# \d ps_vector_coefficients
petascopedb=# \d ps_servicelayer

comment:5 Changed 3 years ago by pcampalani

Fixed in changeset:ff965c7 : for those two tables, (logically) equivalent UNIQUE constraints where set instead of PK constraints (now all tables have a PK index).
Damiano let me know if I can close this one, thanks.

comment:6 Changed 3 years ago by dmisev

  • Resolution set to fixed
  • Status changed from accepted to closed

I think we can obviously close it :)

Note: See TracTickets for help on using tickets.