Re: Strange Type Mismatch on Insert

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

            regards, tom lane