Re: Casting problem

That was it!  I re-defined the related columns and the problem
disappeared. :)

Thanks.

Tom Lane wrote:

> 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
>
>

--
John Burski
I.T. Manager and Systems Administration
911 Emergency Products, Inc.
25 Sixth Avenue North
Saint Cloud, MN  56303
John.Burski@911ep.com

800-863-6911, extension 221
FAX: 800-863-2991
www.911ep.com