Boris Folgmann (boris(at)folgmann(dot)de) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
CLUSTER does not rebuild referential integrity triggers
Long Description
I've got the following behaviour using pgsql 7.2.2 on Linux:
When clustering a table with CLUSTER I get
NOTICE: DROP TABLE implicitly drops referential integrity trigger from table .... for every RI_ConstraintTrigger. The bad thing is that the Trigger is not being reconstructed when the CLUSTER is finished.
Sample Code
\d table_with_ri_triggers
cluster some_index on table_with_ri_triggers
\d table_with_ri_triggers
-> see that ri_triggers are vanished.
No file was uploaded with this report