Re: New software catalog fails (why are we spelling it "catalogue"?) - Mailing list pgsql-www

From Dave Page
Subject Re: New software catalog fails (why are we spelling it "catalogue"?)
Date
Msg-id 937d27e10806110753m4990ecfbl7cd686ec9036640b@mail.gmail.com
Whole thread Raw
In response to New software catalog fails (why are we spelling it "catalogue"?)  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: New software catalog fails (why are we spelling it "catalogue"?)
List pgsql-www
On Wed, Jun 11, 2008 at 3:45 PM, Greg Sabino Mullane <greg@turnstep.com> wrote:
>
>
> Just tried out the new "Submit Product" form and got a
> SQL error:
>
> ===
> Error communicating with database: ERROR: insert or update on
> table "products" violates foreign key constraint
> "products_contact_fkey" DETAIL: Key (contact)=(Greg) is not
> present in table "users".
> ===

Rats. That happens because *%*£$% 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


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


pgsql-www by date:

Previous
From: "Selena Deckelmann"
Date:
Subject: Re: Minor change to community logon
Next
From: "Dave Page"
Date:
Subject: Re: Minor change to community logon