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

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Joan Picanyol i Puig <lists(at)biaix(dot)org>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: insert into view with a defined rule fails from MSAccess
Date: 2002-11-19 03:48:44
Message-ID: 3DD9B49C.B9B69684@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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/

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2002-11-19 03:58:09 Re: Threading crash using ODBC
Previous Message Hiroshi Inoue 2002-11-19 03:41:22 Re: PostgreSQL+ Beta bug?