Re: Update-able View linked to Access

> 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
;


using OLD.husbandctid
------------------------------------
BEGIN;UPDATE "public"."vhusband" 
      SET "tiesize"=3  
      WHERE "id" = 14 
      AND "personctid" = E'(0,63)' 
      AND "husbandctid" = E'(0,42)' 
      AND "name" = E'hel0' 
      AND "tiesize" = 3
ROLLBACK
------------------------------------
Here is my new update rule:

CREATE OR REPLACE RULE 
			vhusband_update_person 
AS ON UPDATE TO 
			public.vhusband
DO INSTEAD
(
	UPDATE 
		public.person
	SET 
		name = NEW.name   
	WHERE 
		id = OLD.id;
	UPDATE
		public.husband
	SET
		tiesize = NEW.tiesize
	WHERE
		id = OLD.id
	AND
		ctid = OLD.husbandctid
)
;

using NEW.husbandctid
---------------------------
BEGIN;
UPDATE "public"."vhusband" 
SET    "name"=E'4'  
WHERE  "id" = 14 
AND    "personctid" = E'(0,63)' 
AND    "husbandctid" = E'(0,42)' 
AND    "name" = E'hel0' 
AND    "tiesize" = 3
ROLLBACK

----------------------------
CREATE OR REPLACE RULE
                        vhusband_update_person
AS ON UPDATE TO
                        public.vhusband
DO INSTEAD
(
        UPDATE
                public.person
        SET
                name = NEW.name
        WHERE
                id = OLD.id;
        UPDATE
                public.husband
        SET
                tiesize = NEW.tiesize
        WHERE
                id = OLD.id
        AND
                ctid = new.husbandctid
)
;

Thanks for the help.

Regards,

Richard Broersma Jr.