On Fri, Mar 14, 2008 at 3:44 AM, James Mansion
<[EMAIL PROTECTED]> wrote:

>
>  And if we use data update triggers to insert into a DELETE ROWS temp
>  table or an in-memory data
>  structure, the BEFORE COMMIT trigger is the place to do a bulk copy into
>  real table(s) or combine
>  rows into a BLOb in an audit table.
>

Another use case of BEFORE COMMIT trigger is to update the row counts
for fast select count(*) operations (of course with some additional
infrastructure)

Thanks,
Pavan

-- 
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to