Re: Update-able View linked to Access

[Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>]

Richard Broersma Jr wrote:
> > Could you try the following ?
> > Add the CTID field of the target table of the last update rule to the
> > definition of the view. In your case, try to add husband.ctid to the
> > definition of vhusband.
>
> I am still getting similar errors, only now both columns are locked.
> Here is my new view definition:
> --------------------------------
> CREATE OR REPLACE VIEW public.vhusband (id, personctid, husbandctid, name, tiesize)  AS
> SELECT
>         A.id, A.ctid, B.ctid, A.name, B.tiesize
> FROM
>         public.person as A
> INNER JOIN
>         public.husband as B
> ON
>         A.id = B.ID
> ;

Please change the field name of B.ctid from hasbandctid to ctid.
The name should be "ctid" for the driver to detect the field is for versioning.
A.ctid isn't needed.

regards,
Hiroshi Inoue