Re: Proposal for db level triggers

On Fri, Mar 14, 2008 at 3:44 AM, James Mansion
<james@mansionfamily.plus.com> 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