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

From: Joan Picanyol i Puig <lists-pgsql-odbc(at)biaix(dot)org>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: insert into view with a defined rule fails from MSAccess
Date: 2002-11-24 20:37:22
Message-ID: 20021124203722.GB56092@grummit.biaix.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

I've applied the patch suggested by Hiroshi, but I still get the same
message. Is there anything I can do to get this to work? Defining rules
for UPDATE and DELETE? Including primary keys in the view?

I find the INSERT INTO vw_centres ... values (?,?,?,?...) and
surrounding lines (return code SQL_NEED_DATA) particularly suspicious.
Why am I getting this when attempting to insert into the vw_centres table?

tks
--
pica

Attachment Content-Type Size
sql.log text/plain 17.2 KB
schema.sql text/plain 16.3 KB

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Tim Noske 2002-11-24 22:10:37 Having problems using ODBC on pgSQL
Previous Message Hiroshi Inoue 2002-11-24 00:14:39 Re: Text field truncation problem