Received: from heidegger.catalyst.net.nz (203-96-145-196.adsl.paradise.net.nz [203.96.145.196]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1D9HTE17786 for ; Wed, 13 Feb 2002 04:17:29 -0500 (EST) (envelope-from andrew@catalyst.net.nz) Received: from 127.0.0.1 (ident=unknown) by heidegger.catalyst.net.nz with esmtp (MasqMail 0.1.16) id 16avWf-7S4-00; Wed, 13 Feb 2002 22:16:29 +1300 Subject: Re: php and Postgres 7.2 From: Andrew McMillan To: rudi Cc: pgsql-php@postgresql.org In-Reply-To: <006301c1b45f$46f83910$0c00a8c0@sun> References: <006301c1b45f$46f83910$0c00a8c0@sun> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/1.0.2 Date: 13 Feb 2002 22:16:29 +1300 Message-Id: <1013591789.10410.116.camel@kant.mcmillan.net.nz> Mime-Version: 1.0 X-Archive-Number: 200202/41 X-Sequence-Number: 947 On Wed, 2002-02-13 at 20:23, rudi wrote: > Hello friends, > > Just a quick email to let you know of my experience upgrading on php apps. > using Postgres 7.1.3 to 7.2 > > The only problem I found was with phorum ( www.phorum.org ) > > I tried the last 2 releases and both would throw this error when creating a new forum : > > Could not add forum to the main table (forums). > Database error: ERROR: value too long for type character(1) . > > I'm not sure why this is occurring but the solution was to run everything on 7.2 > except for this forum application which remains on another box using 7.1.3 > > I don't know if its : > a) the phorum code > b) php > c) Postgres 7.2 > > But I though you may be interested so I've posted it anyway. Someone will correct me if I'm wrong, but 7.1 would silently truncate a value and insert it into the CHAR(1) field. I think what 7.2 is doing is throwing an error when you try to insert a value like 'fred' into such a field where 7.1 would have just put 'f' into the char(1) field. It is probably a bug in phorum for it to be trying to put multi-character values into a char(1) field, so I would tend to look there first. Regards, Andrew. -- -------------------------------------------------------------------- Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267 Are you enrolled at http://schoolreunions.co.nz/ yet?