"Reuven M. Lerner" <reuven@xxxxxxxxxxxx> writes: > Outside of a transaction, this function works just great. But inside of > a transaction, we get the following error message: > Error 55006: Cannot ALTER TABLE "RecipeNumericParameterSnapshot" because > it has pending trigger events. > Now, I've never seen this before, but from poking around online, it > seems that other people were bitten by it as well. My big question is: > What's causing the error? Exactly what it says: not-yet-processed trigger events for the table. If you don't have any explicit triggers on the table, maybe they are FOREIGN KEY implementation triggers. It's hard to say more than that when you haven't shown us any of the DDL. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
