[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Error on creating new customer



On Fri, Feb 09, 2007 at 09:22:25AM +0200, DK wrote:
> I new that I'm lucky.
> =======================
> test1=> insert into customer(name) values ('something');
> ERROR:  attribute 9 has wrong type
> DETAIL:  Table has type character varying, but query expects character varying.
> =======================
> something wrong with postgre I suppose.

Which version of postgres?  If you're using 8.2.2, 8.1.7, or 8.0.10
upgrade now to the next version up.  This is a known issue with those
versions.  If you used a distribution's security release, check for an
update for it, they are also affected.

-- 
Seneca
..hidden..