Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2CNLxx95809
	for <pgsql-sql@postgresql.org>; Mon, 12 Mar 2001 18:21:59 -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.1/8.11.1) with ESMTP id f2CNLft07555;
	Mon, 12 Mar 2001 18:21:41 -0500 (EST)
To: chard <chard@hindang.msuiit.edu.ph>
cc: pgsql-sql@postgresql.org
Subject: Re: help 
In-reply-to: <Pine.LNX.4.21.0103080844360.1788-100000@hindang.msuiit.edu.ph> 
References: <Pine.LNX.4.21.0103080844360.1788-100000@hindang.msuiit.edu.ph>
Comments: In-reply-to chard <chard@hindang.msuiit.edu.ph>
	message dated "Thu, 08 Mar 2001 08:46:46 +0000"
Date: Mon, 12 Mar 2001 18:21:40 -0500
Message-ID: <7552.984439300@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200103/235
X-Sequence-Number: 1894

chard <chard@hindang.msuiit.edu.ph> writes:
> i got an error like this when i do an insert to a table, my table dont
> have bpchar type of field.
> ERROR:  Unable to identify an operator '=' for types 'bpchar' and 'varchar'
>         You will have to retype this query using an explicit cast
> it seems 1 field in my table has bpchar type, but if i view the table
> definition all are varchar and numeric.

I'll bet you have a foreign-key constraint between a varchar field and
a bpchar field in another table.

			regards, tom lane