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

From Jeff Eckermann
Subject Re: insert into view with a defined rule fails from MSAccess
Date
Msg-id 20021118150747.75833.qmail@web20801.mail.yahoo.com
Whole thread Raw
In response to insert into view with a defined rule fails from MSAccess  (Joan Picanyol i Puig <lists@biaix.org>)
List pgsql-odbc
I don't see any attachments.
Can you post the statement that fails, plus
rule/view/table definitions?

--- Joan Picanyol i Puig <lists@biaix.org> 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)
>
> I'm attaching all the logs I can think of,
> connection, debug and
> SQL.LOG. Any ideas?
>
> tks
> --
> pica
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org


__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com

pgsql-odbc by date:

Previous
From: "Bo?ena Potempa"
Date:
Subject: Re: PostgreSQL+ Beta bug?
Next
From: "Hiroshi Inoue"
Date:
Subject: Re: FATAL 1: Sorry, too many clients already