Re: insert into view with a defined rule fails from MSAccess

Joan Picanyol i Puig wrote:
>
> 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)

It's a server side problem not the problem of psqlodbc driver.
Maybe the patch at
  http://archives.postgresql.org/pgsql-general/2002-05/msg00170.php
would fix the problem.
Please try.

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/