[url publishing] fix regression introduced by refactoring in 3.9.7, leading to table view being choosen when one would expect the primary view. Fix similar pb with /<etype> url and list view (this one has been there for a while)

if repo.system_source.dbdriver == 'postgres':
    sql('ALTER TABLE appears ADD COLUMN weight float')
    sql('UPDATE appears SET weight=1.0 ')