sql statements using access frontend

From: "Gavin Mitchell" <gavinm(at)btsgroupuk(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: sql statements using access frontend
Date: 2011-12-02 14:02:33
Message-ID: 754E5D92DE07134DADC851DE2F5C5C6301095334@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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Zuehlsdorff 2011-12-02 14:16:58 Re: How to convert HEX to ASCII?
Previous Message Damien Churchill 2011-12-02 13:58:46 Re: How to convert HEX to ASCII?