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.