insert into view with a defined rule fails from MSAccess - Mailing list pgsql-odbc

From Joan Picanyol i Puig
Subject insert into view with a defined rule fails from MSAccess
Date
Msg-id 20021118014645.GA47353@grummit.biaix.org
Whole thread Raw
Responses Re: insert into view with a defined rule fails from MSAccess  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Re: insert into view with a defined rule fails from MSAccess  (Joan Picanyol i Puig <lists-pgsql-odbc@biaix.org>)
Re: insert into view with a defined rule fails from MSAccess  (Joan Picanyol i Puig <lists-pgsql-odbc@biaix.org>)
Re: insert into view with a defined rule fails from MSAccess  (Joan Picanyol i Puig <lists-pgsql-odbc@biaix.org>)
Re: insert into view with a defined rule fails from MSAccess  (Joan Picanyol i Puig <lists-pgsql-odbc@biaix.org>)
List pgsql-odbc
Hi,

I'm having trouble inserting into a view through an insert rule. I'm
using the latest version the ODBC driver and PostgreSQL 7.2.3 from
MSAccess 2000 on Windows98.

The problem seems to be on ODBC since inserting from psql works.
However, Access returns me Jet error 3156 (something like: the field is too
small for the data you are entering)

I'm attaching all the logs I can think of, connection, debug and
SQL.LOG. Any ideas?

tks
--
pica

pgsql-odbc by date:

Previous
From: "Henshall, Stuart - Design & Print"
Date:
Subject: Re: Error when accessing from MSAccess95
Next
From: "Bo?ena Potempa"
Date:
Subject: Re: PostgreSQL+ Beta bug?