Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA3Fhnq93732 for ; Sat, 3 Nov 2001 10:43:49 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fA3G12c02208; Sat, 3 Nov 2001 11:01:02 -0500 (EST) To: Bhuvan A cc: pgsql-sql@postgresql.org Subject: Re: Strange Problem As Type Casting In-reply-to: References: Comments: In-reply-to Bhuvan A message dated "Sat, 03 Nov 2001 09:09:49 +0530" Date: Sat, 03 Nov 2001 11:01:02 -0500 Message-ID: <2205.1004803262@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200111/37 X-Sequence-Number: 5422 Bhuvan A writes: > test=> UPDATE users set user_id=1 ,login_id='admin' where user_id='1346'; > ERROR: Unable to identify an operator '=' for types 'text' and 'int4' > You will have to retype this query using an explicit cast Got any triggers, rules, or foreign keys for this table? The error is not necessarily in the command you typed, it could be in subsidiary processing. regards, tom lane