projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e79a805) | patch
Avoid duplicate row issues in biblio.extract_located_uris
authorDan Scott <dan@coffeecode.net>
Wed, 15 Jun 2011 01:34:15 +0000 (21:34 -0400)
committerDan Scott <dan@coffeecode.net>
Wed, 15 Jun 2011 01:34:15 +0000 (21:34 -0400)
commit7e6d2bfd7e9a5cbe57e4aacdf0b4b015a566883d
tree48e6be08439b047ad2fbf708459ca1a157cf36a8tree
parente79a805299ec734a29ee5bfa77dc74bc1fd208cdcommit | diff
Avoid duplicate row issues in biblio.extract_located_uris

As there is currently no unique constraint on the non-ID columns of
asset.uri, ensure that we only select a single ID from the tables until
we dedupe the tables. Use an ORDER BY to grab the matching row with the
lowest ID so we can clear out the rows with higher IDs.

Signed-off-by: Dan Scott <dscott@laurentian.ca>
Open-ILS/src/sql/Pg/030.schema.metabib.sql diff | blob | history
Evergreen ILS