Re: Strange Type Mismatch on Insert

On Mon, 19 Mar 2001, Tom Lane wrote:

> Jeff Eckermann <jeckermann@verio.net> writes:
> > Can anyone see what is the problem with the following insert?
> > gmp=# insert into data (site, gmp_id, item, category, gmp) values
> > ('Rochester', 22, 'Design fee', 12, 40000.00);
> > ERROR:  Unable to identify an operator '=' for types 'text' and 'int4'
>
> Got any foreign keys associated with that table?  Check for type
> mismatch between referencing and referenced columns.  It's a bug
> that such problems are not detected when you declare the key
> relationship, but right now they're not detected until runtime...

As an odd side note on that...

I have a fix, using oper() to look for an = operator.  I noticed
while doing that though that varchar and int4 appear to be comparable
while text and int4 aren't which seemed rather odd.