[Gnumed-devel] Backend dem.urb needs cleaner constraint

[Jim Busser]

Currently in dem.urb

Indexes:
    "urb_pkey" PRIMARY KEY, btree (id)
    "urb_id_state_key" UNIQUE, btree (id_state, postcode, name)
    "idx_dem_urb_id_state" btree (id_state)
    "idx_urb_names" btree (name)
    "idx_urb_zips" btree (postcode)


suggest

    "urb_id_state_key" UNIQUE, btree (id_state, postcode, name)

should better be

    "urb_id_state_key" UNIQUE, btree (id_state, UPPER(postcode), UPPER(name))

-- Jim