Postgres Pro
Downloads
Home   >   mailing lists

Re: pre-commit triggers - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pre-commit triggers
Date
Msg-id 10149.1384648978@sss.pgh.pa.us
Whole thread Raw
In response to Re: pre-commit triggers  (Hannu Krosing <hannu@2ndQuadrant.com>)
Responses Re: pre-commit triggers  (Hannu Krosing <hannu@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
Hannu Krosing <hannu@2ndQuadrant.com> writes:
> I have not looked at the patch, but does it also run pre-rollback ?

error in trigger -> instant infinite loop.

Besides, exactly what would you do in such a trigger?  Not modify
the database, for certain, because we're about to roll back.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE TABLE IF NOT EXISTS AS
Next
From: Peter Geoghegan
Date:
Subject: Re: Storing pg_stat_statements query texts externally, pg_stat_statements in core