Quick Links

insert into view with a defined rule fails from MSAccess

From:	Joan Picanyol i Puig <lists(at)biaix(dot)org>
To:	pgsql-odbc(at)postgresql(dot)org
Subject:	insert into view with a defined rule fails from MSAccess
Date:	2002-11-18 01:46:45
Message-ID:	20021118014645.GA47353@grummit.biaix.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-odbc

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

Responses

Re: insert into view with a defined rule fails from MSAccess at 2002-11-18 15:07:47 from Jeff Eckermann
Re: insert into view with a defined rule fails from MSAccess at 2002-11-19 02:10:55 from Joan Picanyol i Puig
Re: insert into view with a defined rule fails from MSAccess at 2002-11-19 03:48:44 from Hiroshi Inoue
Re: insert into view with a defined rule fails from MSAccess at 2002-11-21 00:00:22 from Joan Picanyol i Puig
Re: insert into view with a defined rule fails from MSAccess at 2002-11-22 00:33:25 from Joan Picanyol i Puig
Re: insert into view with a defined rule fails from MSAccess at 2002-11-24 20:37:22 from Joan Picanyol i Puig

Browse pgsql-odbc by date

	From	Date	Subject
Next Message	Hiroshi Inoue	2002-11-18 03:18:38	Re: FATAL 1: Sorry, too many clients already
Previous Message	Robert John Shepherd	2002-11-17 22:15:18	FATAL 1: Sorry, too many clients already