[GENERAL] sql statements using access frontend

2011-12-02 Thread Gavin Mitchell
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 "

Re: [GENERAL] sql statements using access frontend

2011-12-02 Thread Richard Huxton
On 02/12/11 14:02, Gavin Mitchell wrote: 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 "completed

[GENERAL] sql statements using access frontend

2011-12-02 Thread Gavin Mitchell
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 "