Re: MS-Access

Hi Aksels,

When you 'link' or 'attach' the postgres table in access, there should be
an option to tell access which column(s) make up a unique index, typically
the same as the primary key in postgres. If you do that, Access will take
advantage of it and it should help you quite a bit.

Good luck,

Wes Sheldahl

Axel(at)Spallek(dot)ws (Axel Spallek)@postgresql.org on 02/14/2003 04:28:22 AM

Sent by: pgsql-general-owner(at)postgresql(dot)org

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
cc:
Subject: [GENERAL] MS-Access

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

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