Bhuvan A <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster