From: | "Gavin Mitchell" <gavinm(at)btsgroupuk(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | sql statements using access frontend |
Date: | 2011-12-01 10:49:32 |
Message-ID: | 754E5D92DE07134DADC851DE2F5C5C6301095331@bts-mail.btsgroupuk.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
I am getting some strange entries in the postgres logs when updating
data in a linked table using access.
If I create an UPDATE query I get the following entry which looks ok to
me
2011-12-01 10:18:38 GMT LOG: statement: UPDATE "ua"."pole_survey_tbl"
SET "completedby"=E'gavinm' WHERE "pole_survey_id" = 6478
But if the data is changed within the table itself or a form based on
the table or query it starts a transaction and adds all available fields
into the where clause
2011-12-01 10:03:52 GMT LOG: statement: BEGIN;UPDATE
"ua"."pole_survey_tbl" SET "completedby"=E'test' WHERE "pole_survey_id"
= 6478 AND "survey_id" = 1025 and (etc.......)
I chopped the log entry short but there are AND entries fo all fields in
the table
Any help would be much appreciated
Thanks
Gavin Mitchell
From | Date | Subject | |
---|---|---|---|
Next Message | Adarsh Sharma | 2011-12-01 11:46:51 | How to get Place Names from Lat Lon |
Previous Message | Albe Laurenz | 2011-12-01 09:34:29 | Re: Strange problem with turning WAL archiving on |