Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id F31622E009A for ; Wed, 11 Jun 2008 12:26:46 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 00966-06 for ; Wed, 11 Jun 2008 12:26:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.28]) by developer.postgresql.org (Postfix) with ESMTP id 461582E0094 for ; Wed, 11 Jun 2008 12:26:40 -0300 (ADT) Received: by yx-out-2324.google.com with SMTP id 8so315804yxb.73 for ; Wed, 11 Jun 2008 08:26:39 -0700 (PDT) Received: by 10.151.153.14 with SMTP id f14mr443047ybo.73.1213197999596; Wed, 11 Jun 2008 08:26:39 -0700 (PDT) Received: by 10.150.152.11 with HTTP; Wed, 11 Jun 2008 08:26:39 -0700 (PDT) Message-ID: <937d27e10806110826r5afbf33aoc0daa12e59b63171@mail.gmail.com> Date: Wed, 11 Jun 2008 16:26:39 +0100 From: "Dave Page" To: "Greg Sabino Mullane" Subject: Re: New software catalog fails (why are we spelling it "catalogue"?) Cc: pgsql-www@postgresql.org In-Reply-To: <937d27e10806110753m4990ecfbl7cd686ec9036640b@mail.gmail.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> <937d27e10806110753m4990ecfbl7cd686ec9036640b@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/79 X-Sequence-Number: 15306 On Wed, Jun 11, 2008 at 3:53 PM, Dave Page wrote: > 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.... For the benefit of those interested in this sort of thing, I've fixed this by having community_logon() return the userid as found in the database rather than as the user entered, so subsequent code finds it with the correct casing. The userid parameter was already declared INOUT so 'twas a simple change. --=20 Dave Page EnterpriseDB UK: http://www.enterprisedb.com