Skip site navigation (1) Skip section navigation (2)

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

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Joan Picanyol i Puig <lists(at)biaix(dot)org>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: insert into view with a defined rule fails from MSAccess
Date: 2002-11-18 15:07:47
Message-ID: (view raw or whole thread)
Lists: 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(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?

Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-11-18 15:10:02
Subject: Re: FATAL 1: Sorry, too many clients already
Previous:From: Bo?ena PotempaDate: 2002-11-18 14:05:05
Subject: Re: PostgreSQL+ Beta bug?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group