Alvaro Herrera wrote: > create trigger onetest_t before update on onetest for each row > execute procedure upd(); > > insert into onetest select a, repeat('xyzxz', 100), 'new' from generate_series(1, 50) a; > > BEGIN; > SET transaction isolation level SERIALIZABLE; > UPDATE onetest SET description = 'no no', id = 1 where id = 1; > commit; What I don't understand is why this works when the update uses the same target page. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general