MS-Access

From: Axel(at)Spallek(dot)ws (Axel Spallek)
To: and(at)gryffindor(dot)spallek(dot)lan, pgsql-general(at)postgresql(dot)org, Problem(at)gryffindor(dot)spallek(dot)lan, rule(at)gryffindor(dot)spallek(dot)lan, Timestamp(at)gryffindor(dot)spallek(dot)lan, update(at)gryffindor(dot)spallek(dot)lan, view(at)gryffindor(dot)spallek(dot)lan, with(at)gryffindor(dot)spallek(dot)lan
Subject: MS-Access
Date: 2003-02-14 09:28:22
Message-ID: 20030214092822.A85382461B@gryffindor.spallek.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.
I have a Problem with a view of Postgres in Access. I defined some rules to edit 2 of the fields of the view. In pgAdmin with update it works fine.
In Access I get a write-conflict with the option to cancel or put in clipboard.

Why is that?

I searched the internet and found some text telling me to put in a timestamp-field in that table. What should that do? I have several timestamp-fields in my tables and access behaves not different.
I think they mean a timestampfield that is changed by the postgres-server each time the data changes.
One document in the MS-Knowledge base said, that the primary key and that timestampfield have to have an unique index (create unique index to auftraege (auftragsnr,tsfield);)
And the really want to believe me, access is intelligent enough to realize that unique index and to use it instead of comparing each field?

If that is so, do I have to create such an index-field for my view or is it enough to have auftragsnr and tsfield from auftraege in my view.

How do I create a rule, that changes the timestamp-field each time a table-entry is changed?
The following does not work, because it is recursive:

create rule test on update to auftraege do update auftraege set tsfield = current_timestamp where auftragsnr = new.auftragsnr;

Help!

Aksels

Browse pgsql-general by date

  From Date Subject
Next Message Thomas T. Thai 2003-02-14 09:49:20 ezmlm archive to postgresql db
Previous Message jose antonio leo 2003-02-14 08:51:58 uppercase = lowercase