"Stephen Denne" <[EMAIL PROTECTED]> writes:
> What I was asking about with those questions, is if a single row is inserted
> in transaction A, and updated 1000 times still within transaction A, then
> transaction A commits... does a single row version get written, or 1001, 1000
> of which are removable?
Umm ... AFAICS there is no need for an UPDATE to touch the count table
at all. You'd only need ON INSERT and ON DELETE triggers.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
