Re: Pending trigger events on ALTER TABLE in 8.3

Hi, everyone. Tom wrote:

> 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.

Sorry; I'm enclosing the table definition below.

We're not modifying any columns that have constraints or foreign keys.
Only the "Units" column and afterward are affected by running my
"rotate" function.

Recipes=# \d "NumericParameter";
Table "public.NumericParameter"
Column | Type | Modifiers
--------------+------------------------+-----------------------
Name | character varying(255) | not null
RecipeID | uuid | not null
Alias | character varying(255) | not null
Description | text |
IsOptional | boolean | not null
Direction | integer | not null
HostExposed | boolean | not null default true
Units | character varying(255) | not null
DefaultValue | double precision | not null
BoundaryType | integer | not null
Boundary | double precision[] |
Indexes:
"NumericParameter_pkey" PRIMARY KEY, btree ("Name", "RecipeID")
"NumericParameter_idx" btree ("Boundary", "BoundaryType",
"DefaultValue", "Units", "Direction", "IsOptional", "Description", "Alias")
Foreign-key constraints:
"NumericParameter_Recipe_fk" FOREIGN KEY ("RecipeID") REFERENCES
"Recipe"("ID") ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY
DEFERRED
Inherits: "Parameter"

Hmm, could it be that this table inherits from the "Parameter" table
that's causing trouble? The DDL for that table is:

Recipes=# \d "Parameter"
Table "public.Parameter"
Column | Type | Modifiers
-------------+------------------------+-----------------------
Name | character varying(255) | not null
RecipeID | uuid | not null
Alias | character varying(255) | not null
Description | text |
IsOptional | boolean | not null
Direction | integer | not null
HostExposed | boolean | not null default true
Indexes:
"Parameter_pkey" PRIMARY KEY, btree ("Name", "RecipeID")
"Parameter_idx" btree ("Alias", "Description", "IsOptional",
"Direction")
Foreign-key constraints:
"Parameter_Recipe_fk" FOREIGN KEY ("RecipeID") REFERENCES
"Recipe"("ID") ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY
DEFERRED

Thanks again,

Reuven

--
Reuven M. Lerner -- Web development, consulting, and training
Mobile: +972-54-496-8405 * US phone: 847-230-9795
Skype/AIM: reuvenlerner