[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Backend dem.urb needs cleaner constraint
|
From: |
Karsten Hilbert |
|
Subject: |
Re: [Gnumed-devel] Backend dem.urb needs cleaner constraint |
|
Date: |
Sat, 8 Oct 2011 22:40:43 +0200 |
|
User-agent: |
Mutt/1.5.21 (2010-09-15) |
On Fri, Oct 07, 2011 at 08:59:50PM -0700, Jim Busser wrote:
> 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))
Done.
Its's going to be interesting who's going to be first for
whom the upgrade fails because of this.
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346