> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Ümit Öztosun > Sent: Tuesday, February 06, 2007 2:50 PM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: [GENERAL] Very strange error > > > Hi, > > Today suddenly our PostgreSQL 8.1 server started producing strange errors. Error occurs during simple updates: > > "Table has type character varying, but query expects character varying." > > We are still trying to figure out the problem. I've googled for this error but found nothing. Any insight? > > Platform: Ubuntu Dapper, Running PostgreSQL 8.1 (vanilla packages from Ubuntu), UTF-8 and non-US locale. > > Regards, > -- > Ümit Öztosun Have you installed any updates for PostgreSQL? The latest security update fixed something with type checks or so. I've seen the same error message also on the BUGS mailing list concerning a broken CHECK constraint on a table row. Perhaps this is the cause of the error messages. Greetings, Matthias
