Re: ODBC Problem

Friends,
A little more information:

I'm actually only having this problem with some tables that have triggers
on insert, update and delete. A table and the assocaited triggers/functions
shown below. I suspect that something changed in the triggers or functions
in 7.2, but I can't find any documentation on that anywhere.

As before, any help would be greatly appreciated.

Thanks,
Peter Darley

Table "answers_bool"
Column | Type | Modifiers
-----------+--------------------------+-------------------------------------
-----
id | integer | default
nextval('all_answers_seq'::text)
sampleid | integer |
value | boolean |
indicator | text |
surveyid | integer |
time | timestamp with time zone | default now()
Indexes: idx_answers_bool_indicator,
idx_answers_bool_sampleid,
idx_answers_bool_surveyid
Unique keys: answers_bool_idx
Triggers: answers_bool_update,
answer_bool_delete,
answers_bool_insert

CREATE TRIGGER "answer_bool_delete" AFTER DELETE ON "answers_bool" FOR EACH
ROW EXECUTE PROCEDURE delete_time();
CREATE TRIGGER "answers_bool_insert" AFTER INSERT ON "answers_bool" FOR EACH
ROW EXECUTE PROCEDURE insert_time();
CREATE TRIGGER "answers_bool_update" BEFORE UPDATE ON "answers_bool" FOR
EACH ROW EXECUTE PROCEDURE update_time();

CREATE FUNCTION "delete_time"() RETURNS "opaque" AS '
BEGIN
INSERT INTO answers_deleted (SampleID, Indicator) VALUES (OLD.sampleid,
OLD.indicator);
RETURN NULL;
END;
' LANGUAGE 'plpgsql';

CREATE FUNCTION "insert_time"() RETURNS "opaque" AS '
BEGIN
DELETE FROM answers_deleted WHERE SampleID=NEW.sampleid AND
Indicator=NEW.indicator;
RETURN NULL;
END;
' LANGUAGE 'plpgsql';

CREATE FUNCTION "update_time"() RETURNS "opaque" AS '
BEGIN
NEW.time := ''now'';
RETURN NEW;
END;
' LANGUAGE 'plpgsql';

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Peter Darley
Sent: Monday, April 15, 2002 8:41 PM
To: Pgsql-Admin
Subject: [ADMIN] ODBC Problem

Friends,
Yesterday I upgraded from 7.1.3 on RedHat 6.2 to 7.2.1 on RedHat 7.2, and
now I'm having problems with ODBC connections from access on windows. The
problem I'm having is that I am unable to change or delete data; it says
that "The microsoft jet database engine stopped the process because you and
another user are attempting to change the same data at the same time". I'm
able to delete/change data from psql and from my Perl scripts.
Any suggestions on what I might have done wrong?
Thanks,
Peter Darley

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org