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