Opened 3 years ago

Closed 3 years ago

#807 closed defect (fixed)

ps_extra_metadata for ows type metadata incorrectly inserted into GetCapabilities (v9.0.3)

Reported by: jpass Owned by: pcampalani
Priority: critical Milestone: 9.0.x
Component: petascope Version: 9.0.0
Keywords: metadata ows coveragesummary Cc:
Complexity: Medium


I've inserted multiple ows type metadata into the ps_extra_metadata table for example like the below code:

INSERT INTO ps_extra_metadata (coverage_id,metadata_type_id,value) VALUES (
(SELECT id FROM ps_coverage WHERE name = 'glasgow_bhse_b'),
(SELECT id FROM ps_extra_metadata_type WHERE type='ows'),

This works and inserts the following record:

select * from ps_extra_metadata
where metadata_type_id = 1
and coverage_id = (SELECT id FROM ps_coverage WHERE name = 'glasgow_bhse_b');

 id | coverage_id | metadata_type_id | value
 39 |         192 |                1 | <ows:Metadata\r
                                     :   xmlns:ows=""\r
                                     :   xmlns:xlink=""\r
                                     :   xlink:href=""\r
                                     :   about=""/>

The metadata that gets inserted into the GetCapabilities? response (rasdaman 9.0.3 rpm) is:

      <BoundingBox xmlns=""
        crs="" dimensions="2">
        <LowerCorner>254750 659824.9</LowerCorner>
        <UpperCorner>265250 670024.9</UpperCorner>
      <Metadata xmlns="">

Unfortunately, this is invalid.

Change History (3)

comment:1 Changed 3 years ago by pcampalani

  • Status changed from new to accepted

True, thanks for this use case: I'll add a guard to let users insert either ows:Metadata sub-elements (like now is allowed) or directly including the root ows:Metadata.

comment:2 Changed 3 years ago by pcampalani

Fixed in changeset:8e3b54a. Now direct ows:Metadata can also be inserted in petascopedb::ps_extra_metadata.
Let me know James, thanks.

Last edited 3 years ago by pcampalani (previous) (diff)

comment:3 Changed 3 years ago by dmisev

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