Re: Casting problem - Mailing list pgsql-novice

From Tom Lane
Subject Re: Casting problem
Date
Msg-id 3826.1005001553@sss.pgh.pa.us
Whole thread Raw
In response to Casting problem  (John Burski <John.Burski@911ep.com>)
List pgsql-novice
John Burski <John.Burski@911ep.com> writes:
> clocker=# DELETE FROM employee_tbl WHERE emp_id = '1119';
> ERROR:  Unable to identify an operator '=' for types 'varchar' and 'bpchar'
>    You will have to retype this query using an explicit cast

I'll bet you have a foreign-key constraint referencing this table,
and the other column is varchar not char.  7.1 detects unexecutable
FK constraints when you try to create one, but 7.0 didn't, IIRC.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Robert J. Sanford, Jr."
Date:
Subject: Re: Book reviews are up
Next
From: Tom Lane
Date:
Subject: Re: Installing 7.1.3 is missing libssl.0.1