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: 20021118150747.75833.qmail@web20801.mail.yahoo.com (view raw or flat)
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?
> 
> http://archives.postgresql.org


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

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-2014 The PostgreSQL Global Development Group