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

I don't see any attachments.
Can you post the statement that fails, plus
rule/view/table definitions?

--- Joan Picanyol i Puig <lists(at)biaix(dot)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