BUG #8661: Update on all rows in table fails

The following bug has been logged on the website:

Bug reference: 8661
Logged by: J. Heinz
Email address: jheinz(at)zeitwerk(dot)de
PostgreSQL version: 9.1.3
Operating system: MacOSX or Windows
Description:

When we want to update all rows in one table, the sql executes, but didn't
update all rows:

sql: update address set email = 'test(at)test(dot)com';

table:

CREATE TABLE address
(
id bigint NOT NULL,
address1 character varying(255),
address2 character varying(255),
address3 character varying(255),
cdate timestamp without time zone DEFAULT now(),
city character varying(255),
creator character varying(80),
email character varying(255),
fax character varying(255),
internet character varying(255),
mdate timestamp without time zone,
modifier character varying(80),
phone character varying(255),
postalcode character varying(255),
postbox character varying(255),
sourceid bigint,
standard integer DEFAULT 0,
street character varying(255),
usage integer,
vers bigint,
company bigint,
contact bigint,
country bigint,
federalstate bigint,
organisation bigint NOT NULL,
participant bigint,
CONSTRAINT address_pkey PRIMARY KEY (id ),
CONSTRAINT fk_address_company FOREIGN KEY (company)
REFERENCES company (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE,
CONSTRAINT fk_address_contact FOREIGN KEY (contact)
REFERENCES contact (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE,
CONSTRAINT fk_address_country FOREIGN KEY (country)
REFERENCES country (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_address_federalstate FOREIGN KEY (federalstate)
REFERENCES federalstate (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_address_organisation FOREIGN KEY (organisation)
REFERENCES vivenioorganisation (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_address_participant FOREIGN KEY (participant)
REFERENCES participant (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE
)
WITH (
OIDS=FALSE
);
ALTER TABLE address
OWNER TO vivenio7;

-- Index: index_address_city

-- DROP INDEX index_address_city;

CREATE INDEX index_address_city
ON address
USING btree
(city COLLATE pg_catalog."default" );

-- Index: index_address_company

-- DROP INDEX index_address_company;

CREATE INDEX index_address_company
ON address
USING btree
(company );

-- Index: index_address_contact

-- DROP INDEX index_address_contact;

CREATE INDEX index_address_contact
ON address
USING btree
(contact );

-- Index: index_address_country

-- DROP INDEX index_address_country;

CREATE INDEX index_address_country
ON address
USING btree
(country );

-- Index: index_address_email

-- DROP INDEX index_address_email;

CREATE INDEX index_address_email
ON address
USING btree
(email COLLATE pg_catalog."default" );

-- Index: index_address_organisation

-- DROP INDEX index_address_organisation;

CREATE INDEX index_address_organisation
ON address
USING btree
(organisation );

-- Index: index_address_participant

-- DROP INDEX index_address_participant;

CREATE INDEX index_address_participant
ON address
USING btree
(participant );

-- Index: index_address_postalcode

-- DROP INDEX index_address_postalcode;

CREATE INDEX index_address_postalcode
ON address
USING btree
(postalcode COLLATE pg_catalog."default" );

-- Index: index_address_standard

-- DROP INDEX index_address_standard;

CREATE INDEX index_address_standard
ON address
USING btree
(standard );

-- Index: index_address_usage

-- DROP INDEX index_address_usage;

CREATE INDEX index_address_usage
ON address
USING btree
(usage );

-- Trigger: tcmdate on address

-- DROP TRIGGER tcmdate ON address;

CREATE TRIGGER tcmdate
BEFORE UPDATE
ON address
FOR EACH ROW
EXECUTE PROCEDURE setmdate(E'\\\\7800');

-- Trigger: tdeletelog on address

-- DROP TRIGGER tdeletelog ON address;

CREATE TRIGGER tdeletelog
BEFORE DELETE
ON address
FOR EACH ROW
EXECUTE PROCEDURE deletelog();

-- Trigger: tsetdefault on address

-- DROP TRIGGER tsetdefault ON address;

CREATE TRIGGER tsetdefault
BEFORE INSERT OR UPDATE
ON address
FOR EACH ROW
EXECUTE PROCEDURE setaddressdefault(E'\\\\7800');

-- Trigger: tsetfirststandard on address

-- DROP TRIGGER tsetfirststandard ON address;

CREATE TRIGGER tsetfirststandard
BEFORE INSERT
ON address
FOR EACH ROW
EXECUTE PROCEDURE setaddressdefaultfirst();

If we run the update twice we get another number of not updated rows.