INSERT but no UPDATE or DELETE from windows

From: Albert Cervera Areny <albertca(at)jazzfree(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: INSERT but no UPDATE or DELETE from windows
Date: 2003-07-09 13:25:33
Message-ID: 200307091525.39220.albertca@jazzfree.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,
I have Postgres 7.3.3 and ODBC driver 7.03.0100 and as the subject says, I
can INSERT but can't UPDATE nor DELETE. I can also create new tables. The
user has permision to do this as the psql \dp show the correct privileges and
lets me UPDATE without problems using the same user as the ODBC driver.

I open the database as Dynaset (from VB and Visdata) but when I try to
UPDATE or .Edit a record it says something like 'should use an updatable
query' (translated from spanish).

The odbc connection is not, of course, read only.

Any ideas of what's going on here? This worked well a couple of weeks ago and
the only thing I can think I could have modified is the PostgreSQL version
(probably updated from 7.2.x to 7.3.3). Could this be the cause? How could I
work arround this?

Thanks in advance!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/DBfSTK7ZP4pDOHcRAiswAJ9yJa6MCBgFnszjWaBdMwdJKF4ApACghwC3
eX/pkUfoKyM46Xlc/Ez846s=
=I91X
-----END PGP SIGNATURE-----

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message J P 2003-07-09 19:53:56 Small but annoying Excel numeric import problem
Previous Message John Herreshoff 2003-07-08 16:03:46 Fwd: Re: [NOVICE] OK..time for STUPID to say somthing