RE: Strange Type Mismatch on Insert

Absolutely right.  I've been editing my setup script, and a mistake crept
in.  Obvious in retrospect, but then this is the first time I've actually
used referential integrity features...
Thanks for saving my sanity yet again!

> -----Original Message-----
> From:    Tom Lane [SMTP:tgl@sss.pgh.pa.us]
> Sent:    Monday, March 19, 2001 6:27 PM
> To:    Jeff Eckermann
> Cc:    'pgsql-general@postgresql.org'
> Subject:    Re: [GENERAL] 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