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

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 (view raw or flat)
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

pgsql-odbc by date

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

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