INSERT but no UPDATE or DELETE from windows
От | Albert Cervera Areny |
---|---|
Тема | INSERT but no UPDATE or DELETE from windows |
Дата | |
Msg-id | 200307092144.42958.albertca@jazzfree.com обсуждение исходный текст |
Список | pgsql-general |
-----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! PS: Sorry for those that also receive pgsql-odbc but I really need this working as soon as possible -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/DHCpTK7ZP4pDOHcRAhTsAJ4k5hyThvhJ4Kb0SxtDNJMYcoAZzACffH8s 9Nan5qw3fexbkBpb1a0FTAc= =IN1R -----END PGP SIGNATURE-----
В списке pgsql-general по дате отправления: