Re: MS Access/ODBC 'ERROR: invalid input syntax for integer: "A"'

On Mar 28, 2005, at 10:57 AM, mg wrote:

> I've searched http://search.postgresql.org/ and Google on this error 
> to no
> avail.  I suspect this problem relates to the integer / single quote 
> issue
> referenced in previous posts.  It may also relate to the domain I 
> created,
> but I'm not sure how to proceed.
What happens if you just define id as int4 rather than using the 
domain? I'm not really familiar with ACCESS/ODBC, but I'm wondering if 
it really knows anything about domains.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match