Message-ID: <937d27e10806110753m4990ecfbl7cd686ec9036640b@mail.gmail.com>
Date: Wed, 11 Jun 2008 15:53:17 +0100
From: "Dave Page" <dpage@pgadmin.org>
To: "Greg Sabino Mullane" <greg@turnstep.com>
Subject: Re: New software catalog fails (why are we spelling it "catalogue"?)
Cc: pgsql-www@postgresql.org
In-Reply-To: <34153382302f195bf55fa71338367f0c@biglumber.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <34153382302f195bf55fa71338367f0c@biglumber.com>

On Wed, Jun 11, 2008 at 3:45 PM, Greg Sabino Mullane <greg@turnstep.com> wr=
ote:
>
>
> Just tried out the new "Submit Product" form and got a
> SQL error:
>
> =3D=3D=3D
> Error communicating with database: ERROR: insert or update on
> table "products" violates foreign key constraint
> "products_contact_fkey" DETAIL: Key (contact)=3D(Greg) is not
> present in table "users".
> =3D=3D=3D

Rats. That happens because *%*=A3$% MediaWiki insists on re-casing names
so we had to make the logon code case-insensitive. You need to logon
using the same casing as we have stored in the database to satisfy the
foreign key. Meanwhile, I'll be fixing up the code to try to handle
that....

Oh, and it's 'catalogue' because that's how catalogue is spelt. In
English. In England. If you broke the spelling on your side of the
pond then that's your look out :-p


--=20
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com