Fran Fabrizio <ffabrizio(at)mmrd(dot)com> writes:
> I seem to be observing that on a trigger I've created to fire
> AFTER INSERT, if I intentionally introduce some sort of syntax error to
> the trigger for example, and insert a row, the row does not appear in
> the table, even though I've declared it to fire after insert. Shouldn't
> that row be there regardless of whether the trigger does or does not
> fire successfully?
No. Failure of an AFTER trigger will still abort the transaction.
regards, tom lane