Trigger Update Issue - Mailing list pgsql-general

Hello All

I'm running 7.3.4-1 on a RH9 box.  I'm having a problem with a trigger
that seems to execute without actually performing the update that it
should.  The update returns true everytime however if it is the first time
that the trigger executes on a given row, the column is not updated.  The
column is updated correctly on subsequent calls.

Here is the code:

create table tabA (
  id     char(32) primary key not null,
  Acol1   char(40) not null unique,
  Acol2   integer not null,
  Acol3   integer default 0 check ( Acol3 >= 0),
);

create table tabB (
  id            integer default nextval('tabB_id_seq'::text)
                not null check (id > 0) primary key,
  tabA_id       char(32) not null references tabA (id)
                on delete cascade on update cascade,
  Bcol1          text default null,
  Bcol2          text default null,
);


CREATE OR REPLACE FUNCTION "tabB_postinsert" () RETURNS TRIGGER AS '
  --
  -- Actions to take after inserting into tabB
  --
  BEGIN
    -- Increment tabA.attachments
    UPDATE tabA SET Acol3 = Acol3 + 1 WHERE id = NEW.tabA_id;
    -- done
    RETURN NEW;
  END; ' LANGUAGE 'plpgsql';

CREATE TRIGGER "master_tabB_postinsert"
  AFTER INSERT ON "tabB"
  FOR EACH ROW EXECUTE PROCEDURE "tabB_postinsert" ();

I am using this same trigger structure on other tables without having any
issues.  Any insight would be greatly appreciated.

Thanks

-b